List the boat name, owner number, owner last name, and owner first name for each boat...

Transcribed Image Text:

List the boat name, owner number, owner last name, and owner first name for each boat in marina 1 sorted by boat name. The query should produce this output: Command Prompt-sqlite3 alexamara.db Owner Num Last Name AN75 EL25 KE22 Boat Name Anders II Our Toy Escape 3092 Gypsy Anders III AN75 sqlite> Anderson Elend Kelly Juarez Anderson List the slip ID, boat name, owner number, service ID, number of estimated hours, and number of spent hours for each service request on which the category number is 2. The query should produce this output: Boat Nane Anders 11 Brave Brave Listy Owner Mun AN75 AD57 AD57 SM72 First Name Bill Sandy and Alyssa Maria Bill Service ID ? 13 Est Hours Spent Hourt Apply the count function to count the number of boats per marina. Change the column heading by using the alias "Number of Boats'. Hint: group the records by the marina number. The query should produce this output: Marina Num Number of boats Come up with your own example to implement GROUP BY and HAVING in your query List the boat name, owner number, owner last name, and owner first name for each boat in marina 1 sorted by boat name. The query should produce this output: Command Prompt-sqlite3 alexamara.db Owner Num Last Name AN75 EL25 KE22 Boat Name Anders II Our Toy Escape 3092 Gypsy Anders III AN75 sqlite> Anderson Elend Kelly Juarez Anderson List the slip ID, boat name, owner number, service ID, number of estimated hours, and number of spent hours for each service request on which the category number is 2. The query should produce this output: Boat Nane Anders 11 Brave Brave Listy Owner Mun AN75 AD57 AD57 SM72 First Name Bill Sandy and Alyssa Maria Bill Service ID ? 13 Est Hours Spent Hourt Apply the count function to count the number of boats per marina. Change the column heading by using the alias "Number of Boats'. Hint: group the records by the marina number. The query should produce this output: Marina Num Number of boats Come up with your own example to implement GROUP BY and HAVING in your query

Answer rating: 100% (QA)

Schema was not provided in the question got schema from the net and thisschema is at the bottom of this answer If schema was different or any questions ask via comments Queries 1 select BoatName as Bo... View the full answer