Assignment Lab: Running Queries in DB Browser Part 2.

Assignment Instructions
From Unit 2, PowerPoint Presentation in part 2, run all the queries in DB Browser. Save each query as instructed in the following video.

When finished with your assignment, submit the three following files:

The database file ( .db format)
The SQL scriipt file. ( a .sql file)
A “screenshot” file showing the results of the SQL scriipt. (a Word or PDF file)

Add a comment to name your queries according to the slide number as instructed in the following video. Begin the comment with — (two hyphens)
Example:

— Slide 19

SELECT SUM(ExtendedPrice) AS WaterSportsRevenue

FROM ORDER_ITEM

WHERE SKU IN

(SELECT SKU

FROM SKU_DATA

WHERE Department = ‘Water Sports’);