Complete the following Queries using the northwind vm 1. List all the Customer c

ID: 3744175 • Letter: C

Question

Complete the following Queries using the northwind vm

1. List all the Customer company names and the cities they are from

2. What customers are from Madrid?

3. Why does a query for Montreal return no results even though there is a customer from there?

4. How many suppliers are there?

5. Add yourself as a new shipper

6. How many orders were made by CHOPS

7. What is the earliest order date?

8. What is the largest freight size?

9. What does CRUD stand for?

10. Why is the following statement bad?

Update myAddressBook set state=’Virginia’

11 What are two ways you could protect yourself from the issue in the previous question?

Select CustomerID,CustomerName,City from Customers;

Select CustomerID,CustomerName from Customers where City = 'Madrid';

Select count(SupplierID) from Suppliers ;

Insert into Shippers(7686,'mycompany','87879070');

Select count(OrderID) from OrderDetails inner join Products on OrderDetails.ProductID = Products.ProductID where ProductName = 'CHOPS';

Select min(OrderDate) from Orders;

Select max(Freight) from Orders;

CRUD stand for Create ,Read,Update and Delete data using forms and reports.

10.

There is no condition with update statement. So all records of myAddressBook table will be updated with state=’Virginia’

add where clause with one or multiple conditions

Do ask if any doubt. Please upvote.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.