Assignment 3: SQL (8% of the course mark)Your task in this assignment is to write 10 SQL queries in the context of the provideddatabase. We recommend that you attempt to draw the ERD to better understand the data model. However, you are not required to submit your ERD.Late submissions are not allowed.Your task is to formulate 10 SQL queries to retrieve the following information from the given database implementation. We do not want you to provide us with the query results, just give us your queries and wewillrun your queries against the given database.1.List all the books that are priced $20.00 or less. Display the result in decreasing order of price.2.List the books that have word Harry in their names (book titles).3.List all the customers who live in Los Angeles or Wichita.4.List all the books for which any orders have been placed. Display the result in increasing order of the book id and do not repeat the book details.5.List all the customers along with their book orders for whom book orders have not yet been shipped.6.List all the customers whose first names or last names begin with letter A.7.List all the customers who ordered who placed book orders forbetween 15-Aug-2018 and 18-Aug-2018. Display your results in the increasing order of the customer number and the date order is placed.8.Get the average book price and average quantity on hand.9.List all the employees who have served the customers with the same zip code. The list should also include customer name, zip.10.List all the employees who were born after the year 1996.First,downloadthedatabase (called BookMailOrderDatbase, link above) from the stream and open the database using DB Browser for SQLite. Spend some time understanding the data model (e.g. understand what the tables are, what do attributesrepresent, what are the primary keys, what are the foreign keys and draw an ERD) and thendevelop your queriesusing DB Browser for SQLite. Make sure you submit yourSQL queriesvia STREAM simply paste your queries into the assignment submission interface (pleasedo notcreate a separate document).Important: For marking,we will run your queries against our database.YouDO NOTneed to submit your database or ERD.Use the given criteria only and in your output display what is asked but do include all the relevant columns to make the information meaningful and query results verifiable. You might have to do some research on SQL to finish the assignment (slightly more challenging than the lecture and/or lab work).Do not collaborate and/or share your answers with others.How this assignment is going to be marked?This is the provisional marking scheme:Total 8 marks. Questions 1-4 are worth .5 mark each and questions 5-8 are worth 1 mark each.

所有的编程代写范围：essayghost为美国、加拿大、英国、澳洲的留学生提供C语言代写、代写C语言、C语言代做、代做C语言、数据库代写、代写数据库、数据库代做、代做数据库、Web作业代写、代写Web作业、Web作业代做、代做Web作业、Java代写、代写Java、Java代做、代做Java、Python代写、代写Python、Python代做、代做Python、C/C++代写、代写C/C++、C/C++代做、代做C/C++、数据结构代写、代写数据结构、数据结构代做、代做数据结构等留学生编程作业代写服务。