MGMT 2080 Introduction to Information Systems SQL 1 Assignment

8 points

For each task, copy the SQL from phpMyAdmin to MS Word. Take a screen shot of the appropriate window in phpMyAdmin to show the SQL worked and paste it beneath the SQL in MS Word.

USE northwind DATABASE TO ANSWER QUESTIONS BELOW

1. How many customers live in Argentina? Include CompanyName, ContactName, and Country in your results. Sort by CompanyName in ascending order.

1. Which products are in the Beverage category? Include ProductName and CategoryID in your results. Sort by ProductName in ascending order.

1. Which products have a UnitPrice between $20 and $30? Include ProductName and UnitPrice in your results. Sort in descending order by UnitPrice.

1. Which employees are sales representatives and live in London? Include FirstName, LastName, Title, and City in your results. Sort in ascending order by LastName.

1. Which orders were shipped via Speedy Express to France with a freight less than 50 pounds? Include OrderID, CustomerID, Freight, and ShipCountry in your results. Sort in descending order by Freight.