North Lake College SQL Sequence Query Language Execise

ASSIGNMENT ONE:

You will be writing 5 different queries. Use the editor in W3Schools to write your SQL statements. Create a Word document and take a screenshot of each of the following numbered items at the bottom ( 1 – 5 ) (SQL statement as well as first page of results). Submit the word document when complete. https://www.w3schools.com/sql/

Example:

Try typing:

Select CustomerName FROM Customers;

in the SQL Statement area.

Use the <Run SQL> button to look at the results. Click on the <Run SQL

https://www.w3schools.com/sql/

1. Write a selection statement that returns all the fields, but will choose only the customers in Germany and Sweden and sort them alphabetically by country. You should have retrieved 13 records.
2. Write a statement that returns all the fields and records except Germany. Sort by City. You should have retrieved 80 records.
3. Add a statement to number 2 that will return the first 10 results only.
4. Write a statement that will return only those Orders with a Quantity less than 15 (Look in OrderDetails table). You should have retrieved 166 records.
5. Use the previous query (number 4) and return only those records that have productID of 11. You should have five records.