Description
I need someone to help with my question please read the question very well then answer carefully. Also I need u to replay for 2 students (it’s in the word doc)
We do not write the SQL language and syntax and instead use an Access query-by-example (QBE) interface. However, the WHERE statement is what we spend a significant amount of time on as it allows us to set criteria for the results that we get back from the database instead of getting all the data.
As a warm-up for Assignment III, let’s examine some of the WHERE clause operators that are available in any relational database.
Your task:
Pick one of the 8 tables that are part of the example W3 Schools online example database:
https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all (Links to an external site.)
Clicking on the table name on the right-hand side of the screen will show the data for that table.
Then describe what criteria that you would use in order to restrict the data to what you are looking for. Challenge yourself to use two columns in your criteria or a more advanced concept like “IS NOT NULL” or IN/BETWEEN. Do not repeat other student’s examples.
My example:
Table: Order Details
Task: Find those orders that included Uncle Bob’s Organic Dried Pears with a quantity between 20-30
Operators:
ProductID = 7 AND Quantity BETWEEN (20 AND 30)
—-
Notes:
A good list of operators can be found at:
https://www.techonthenet.com/sql/comparison_operators.php (Links to an external site.)
Also, the W3 website has the capability to run a query but that is not required.
Unformatted Attachment Preview
Student replay
I decide to go with the orders table for this discussion. The database owner is
contemplating discontinuing their accounts with specific shipping vendors so
they decide to review orders from 1997 and on.
Table: Orders
Task: Identify orders made in the year 1997 or later that were shipped by
United Packaging or Speedy Express
Operators: WHERE OrderDate >= 1997-01-01 AND ShipperID in (1,2)
Purchase answer to see full
attachment
