1. Find customers whose City is "London", or Whose Country is "USA". List CustomerName, City, and Country of such custom

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

1. Find customers whose City is "London", or Whose Country is "USA". List CustomerName, City, and Country of such custom

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”