I’m working on a Health & Medical exercise and need support.

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.