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 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
Get step-by-step solutions from verified subject matter experts
