Question
Customer ID Customer Name City Grade Salesman ID 3002 Nick Rimando New York 100 5001 3005 Gaham Zusi California 200 5002 3001 Grad Guzan London
Customer ID Customer Name City Grade Salesman ID
3002 Nick Rimando New York 100 5001
3005 Gaham Zusi California 200 5002
3001 Grad Guzan London 100 5005
3004 Fabian Johns Paris 300 5006
3007 Brad Davis New York 200 5001
3009 Geoff Camero Berlin 100 5003
3008 Julian Freen London 300 5002
3003 Jozy Altidor Mosow 200 5007
Write a SQL statement to display all customers, who either belongs to he city New York or hd a grade above 100, and also display Name and grade of all customers whose name starts from letter 'B' or 'G' and arrange the result in ascending order
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started