SQL Queries for Rousseau's Furniture Database

Query 1

The Queries – Using the Rousseau’s Furniture database that we will put together during class time. Write a single statement for each query requested below. Include helpful comments. Remember to verify the result of your query is the correct result!

Query 1
Write a select statement that will list a customer's company name, their first and last names and their city in that order. Only include customers that are NOT located in Oshawa.

Query  2
Write a select statement that will retrieve all the columns of all the records that have an invoice date earlier than June 1, 2018.

Query  3
Write a select statement that will retrieve all the columns of all the records that have an invoice date between June 1, 2018 and the end of the year.

Query  4
Write a query that will list customers that are either a university or college. Provide the customer company name along with their first and last names. 

Query 5
Write a query that will display the total number of invoices with HST due over $275. Your column should display with the alias "Over $275".

This is what you need to use to self-assess, and it will be what your professor uses to grade your submission. Complete the self-assessment column in the table below, then save the document and be sure to submit it along with your work.

Result Set – 6 marks (50%), all or nothing.
Does the query run and provide the CORRECT result set? All or nothing.

Select – 2 marks per query.
Each SELECT clause is accurately formed to request exactly the requested fields, returning the correct result.

From – 2 marks per query.
Each FROM clause is accurately formed to retrieve data from the necessary table, returning the correct result.

Where– 2 marks per query.
Each WHERE clause is accurately configured to return the correct result.