Question: Using the following table, write appropriate queries. Table 1. Customers Table 2, Orders a. Write query to select the first name and last name of

 Using the following table, write appropriate queries. Table 1. Customers Table

Using the following table, write appropriate queries. Table 1. Customers Table 2, Orders a. Write query to select the first name and last name of all customers. b. Select all customers from the Customers table with last_name Doe. c. Select all customers from the Customers table having age greater than 25. d. Select all customers from the Customers table having last_name Doe and country USA. e. Write a query to have a table with customer_id, customer first_name and order amount which the amount is greater than or equal to 500

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!