You will learn to write and execute some basic SQL queries for a new database, Ski New England. Ski New England is a database that contains stores, manages and allows information retrieval on all New England ski resorts. It has the following schema.

Write the proper syntax in SQL language for the following queries. Make sure that you write (type out) each query. The output of each query must follow the display format given, including the title names.

LID: int(10) unsigned R ID: int(10) unsigned name: varchar(200) catacity : varcha(10) R ID: int 10) unsigned r tie:varchar(50) r area: int 11) r elevation: int(11) r street:varchar(50) r city: varchan(20) r state: varchar(2) r_zip: varchar(9) al type:varchar(10) LID: int(10) unsigned TID: in 10) unsigned T ID:Int(10) unsigned .R ID: int10) unsigned t name:varchar(200) color: varcharl 15) P ID:Int(10) unsigned R ID: Int(10) unsigned P price: Int(11) p type: varchar(10) p shift: varchar(10) p age Group: varchar 20) .R JD: int Query 6. What is the area of the largest ski resort in New England? Output this area as: Largest Ski Resort Area in New England Query 7. Which is the largest ski resort in New England? Largest Ski Resort in New England Query 8. Find the smallest ski resort in New England. Print the ski resort name and its area. Resort Name Smallest Area Query 9. Count and display the number of ski resorts New England. Total Number of Ski Resorts in New England Query 10. Count and display the number of ski resorts in each state of New England State Total Number of Ski Resorts in State