Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions