database lab 3

For this assignment follow the instructions and watch the you tube video:

Put the SQL syntax from the following questions into the online text box on this assignment. Make sure that your SQL syntax runs correctly before submitting it, I recommend copy and pasting the correct syntax after you run it! The queries are all to be run on the CIS database server at: https://boss.vvc.edu/database_access/

SELECT #1
From the customers table show all fields
Restrict the records to only show customers from the Galactic Republic of Mars
Order the records by the last_name field then secondarily by the first_name field

SELECT #2
From the products table show all fields
Restrict the records to only show products where the unit_of_issue is equal to EA
Order the records by the units_in_stock field

SELECT #3
From the employees table show first_name, last_name, nickname
Restrict records to only show employees where the the country is equal to “US” and the first_name field is equal to “Clark”
Order the records by the nickname field

SELECT #4

From the orders and customers table show order_num, order_date,first_name,last_name

Restrict records to only show the city equal to New York.

Note: You must join the tables or else you will end up with a Cartesian Product!

SELECT #5

From the customers, orders and shippers table show the first_name, last_name, shipper name (change name of the displayed field to ‘Shipped From’), order_id,order_num

Restrict records to show only freights greater than 55 and only Fedex shipments.

Note: You must join the tables or else you will end up with a Cartesian Product!

Place New Order
It's Free, Fast & Safe

"Looking for a Similar Assignment? Order now and Get a Discount!

Feeling Lucky?

Enter your email address to spin the wheel for a chance to win exciting offers.