Write a sql statement to display names and city of salesman, who belongs to the city of paris

Select all records where the City column has the value 'Berlin' or 'London'.

Índice Show

Practice Online
Query Visualization:

@(6) * FROM Customers @(5) City = 'Berlin' @(2) @(4) = '@(6)';

SELECT * FROM Customers WHERE City = 'Berlin' OR City = 'London';

Correct!

Next ❯

e. Write a SQL query to display those customers who are neither belongs to the city New York nor grade valueis more than 100.

Last update on August 19 2022 21:50:36 (UTC/GMT +8 hours)

From the following tables write a SQL query to find the salesperson and customer who reside in the same city. Return Salesman, cust_name and city.

Sample table: salesman

Sample table: customer

Sample Solution:

SELECT salesman.name AS "Salesman", customer.cust_name, customer.city FROM salesman,customer WHERE salesman.city=customer.city;

Output of the Query:

Salesman cust_name city James Hoog Nick Rimando New York James Hoog Brad Davis New York Pit Alex Julian Green London Mc Lyon Fabian Johnson Paris Nail Knite Fabian Johnson Paris Pit Alex Brad Guzan London

Explanation:

Pictorial presentation:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous SQL Exercise: SQL JOINS Exercises Home
Next SQL Exercise: Customers and their cities for given range of orders.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

WHERE vs HAVING?

WHERE is applied before GROUP BY, HAVING is applied after (and can filter on aggregates).

In general, you can reference aliases in neither of these clauses, but MySQL allows referencing SELECT level aliases in GROUP BY, ORDER BY and HAVING.

Ref : https://bit.ly/3FeA9Qn