•Your queries should produce the expected result (including column names, grouping, duplicate removal, and ordering) shown in each information request below.

Using the database provided, write SQL queries that satisfy the following information requests.
•Your queries should produce the expected result (including column names, grouping, duplicate removal, and ordering) shown in each information request below.
•Your queries must order the result as requested.  If the information request does not mention a required ordering, your query does not need to order the result.
•Where appropriate, your queries must remove duplicates from the result.
•Simple queries are preferred.  Marks may be lost for unnecessarily complex queries.
List Customer name and address (Street, Suburb, State and Postcode) for all Victoria customers, as shown below.  List results alphabetically by customer name.  A single column result is required.  
List customers from the state of QLD or NSW who have not provided an email address (i.e. the email address is null).                  


Price: £ 72

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh