1. Customers and internet packages (Customers and Packages tables) a. Write a query to display first name, last name , package number and internet speed for all customers. b. Write a query to display first name, laast name, package number and internet speed for all customers whose package number equals 22 or 27. Order the query in ascending order by last name.
1. Customers and internet packages (Customers and Packages tables)
a. Write a query to display first name, last name , package number and internet speed for all customers.
b. Write a query to display first name, laast name, package number and internet speed for all customers whose package number equals 22 or 27. Order the query in ascending order by last name.
2. Internet packages and sectors.
a. Display the package number, internet speed, monthly payment and sector name for all customers.
b. Display the customer name, package number, internet speed , monthly payment and sector name for all customers ( Customers , Packages and Sectors tables).
c. Display the customer name, package number, internet speed, monthly payment and sector name for all customers in the business sector (Customerss, Packages and sectors tables).
3. Display the last name, first name, join date, package number, internet speed and sector name for all customers in the private sector who joined the company in the year 2006.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps