1. Find customers whose City is "London", or Whose Country is "USA". List CustomerName, City, and Country of such custom
Posted: Sun Jul 03, 2022 11:22 am
1. Find customers whose City is "London", or Whose Country is"USA". List CustomerName, City, and Country of such customers. Sortthe result first by the ascending order of Country, then bydescending order of City, and finally by descending order ofCustmerName.
2. List the counting number of suppliers for which theSupplierName starts with letter "P". Rename the column name of yourresult as CountingNumber.
2. List the counting number of suppliers for which theSupplierName starts with letter "P". Rename the column name of yourresult as CountingNumber.