Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer question #2 with pics I have attached q1.sql (the example for question1) on BlackBoard You should put this SQL query into the appropriate

please answer question #2 with pics image text in transcribed
image text in transcribed
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 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 Show all unique Ship company Names ordered by ascend from the table which name is Order and contain a symbol '-' (5 points) The example list below only prints the ship company name that contain a symbol ".' Modify the commands on the example to finish the questions

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Fred R. McFadden, Jeffrey Slater, Mary B. Prescott

5th Edition

0805360549, 978-0805360547

More Books

Students also viewed these Databases questions