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’);
To view the results of a specific query, select the query you want to execute and then click on the execute button. This will show the output related to the selected query.
Capture a screenshot of the entire DB browser window, including the query and its output.
Combine the screenshots by copying and pasting them into a single Word document file. Afterward, submit the file in either Word or PDF format.
