Write an SQL Statement that displays wholesaler’s business name and the city they are based in.
Task 4 (2 marks)
Write an SQL Statement that displays details of shop (address, city, state and contact number). Contact number should not have the area code. In other words, the first two digits in contact number must not be displayed
Task 5 (3 marks)
Write an SQL Statement that displays details from appliance table (name, year of manufacture and price) and perform a multi-level sorting [year of manufacture (descending) followed by price (ascending)]. Price has to be displayed with a ‘$’ character in the output.
Task 6 (3 marks)
Write an SQL Statement that displays all details of shops from ‘NSW’ or ‘VIC’ if they address has the letter ‘O’ somewhere in it.
Task 7 (3 marks)
Write an SQL Statement that displays delivery details -id, city and state the delivery is scheduled for and the total cost of the delivery (you need to calculate this value). Show delivery only if the date of delivery is on or after 20th of August, 2015. Use proper alias for any computational columns.
Task 8 (3 marks)
Write an SQL Statement that displays the shop details -id and the total number of appliances delivered to each shop and sort the results by shop id.
Task 9 (3 marks)
Write an SQL Statement that displays all columns from Delivery and Wholesaler tables with just one instance of Wholesaler ID Column.
Task 10 (4 marks)
Write an SQL Statement that displays delivery details (id, date of delivery and quantity), if the quantity is less than 20 or over 30 and date of delivery is after 15th of August, 2015. Sort the results by date of delivery.
Task 11 (4 marks)
Write an SQL Statement that displays the details of shops (address, city and state) that have been supplied by wholesalers from NSW, TAS, NT and WA.
Note: Make sure there is no redundant data displayed.
Task 12 (5 marks)
Write an SQL Statement that displays the names of the states and a corresponding count of deliveries to shops in those states. Display only the states that have 3 letters in their name. Sort the results by the count of deliveries in descending order.
Task 13 (5 marks)
Write an SQL Statement that displays all details of appliances if they are delivered on 21st of August, 2015 or on the 29th of August, 2015
Task 14 (5 marks)
Write an SQL Statement that displays only top 3 wholesalers’ business names and their corresponding average of quantities. (Top 3 businesses are those who have the highest average in the quantity of items)
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]