From the following tables write a SQL query to display the cust_name, customer city, grade, Salesman, salesman city. The result should be ordered
- برمجة سي كيو ال sql
- 2021-09-01
- mhanasmh00489829403
الأجوبة
SELECT a.cust_name,a.city,a.grade,
b.name AS "Salesman",b.city
FROM customer a
LEFT JOIN salesman b
ON a.salesman_id=b.salesman_id
order by a.customer_id;
Output of the Query:
cust_name city grade Salesman city Brad Guzan London Pit Alex London Nick Rimando New York 100 James Hoog New York Jozy Altidor Moscow 200 Paul Adam Rome Fabian Johnson Paris 300 Mc Lyon Paris Graham Zusi California 200 Nail Knite Paris Brad Davis New York 200 James Hoog New York Julian Green London 300 Nail Knite Paris Geoff Cameron Berlin 100 Lauson Hen San Jose
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال