This paper circulates around the core theme of •Your queries should produce the expected result (including column names, grouping, duplicate removal, and ordering) shown in each information request below. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
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).