Question: I have attached q1.sql (the example for question1) on BlackBoard You should put this SQL query into the appropriate file extend by sql(q1.sql) in the

I have attached q1.sql (the example for question1) on BlackBoard You should put this SQL query into the appropriate file extend by sql(q1.sql) in the same directory as the db file. Follow the command listed on the below to run the query in the file E: ICSC315 1 HOMEWORK1>sqlite 3 northwind. db " . read q1.5q1." Beverages Condiments Confections Dairy Products Grains/Cereals Meat/Poultry produce seafood E: ICSC 315\ HOMEWORK1> Please submit THREE sql file(s) follow the q1 on BlackBoard. Comments should be followed by - on sql file List all Category Names ordered alphabetically by decent( 5 points). The example list below is order by ascent Modify the commands on the example to finish the questions E: ICSC315\HOMEWORK1>sqlite3 northwind. db SQLite version 3.39.2 2022-e7-21 15:24:47 Enter ". help" for usage hints. sqlite> SELECT CategoryName FROM Category ORDER BY CategoryName; Beverages Condiments Confections Dairy Products Grains/Cereals Meat/Poultry produce Seafood sqlite>
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
