Question: solve asap. Q5: From the Customer table given below write SQL queries for the following question? (7.5 marks) Write a query to display the record

solve asap.
Q5: From the Customer table given below write SQL queries for the following question? (7.5 marks) Write a query to display the record of the last name and city with unique state? Write a query to display the record of the distinct cities of the customers? Write a query to display the records of customers' address whose names contain letter "a"? customer_id first_name last_name address 1 Ahmed Mustafa 32 Gulshan Iqbal Road 2 Karim Khan 4300 Bank Road Ahmed Ali 931 Gulburg Road Muhammad Hamza H.No.16, Street 1, H-8/3 Daud Ibrahim 2050 Shahraey Faisal city state Lahore Punjab Rawalpindi Punjab Rawalpindi Punjab Islamabad Punjab Karachi Sindh 3 4 5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
