w3resource

SQL: Select order number, order date and the purchase amount for each order delivered by a salesman

SQL Basic Select Statement: Exercise-11 with Solution.

From the following table, write a SQL query to find orders that are delivered by a salesperson with ID. 5001. Return ord_no, ord_date, purch_amt.

Sample table: orders


Sample Solution:

SELECT ord_no, ord_date, purch_amt
FROM orders
WHERE salesman_id=5001;

Output of the Query:

ord_no	ord_date	purch_amt
70002	2012-10-05	65.26
70005	2012-07-27	2400.60
70008	2012-09-10	5760.00
70013	2012-04-25	3045.60

Relational Algebra Expression:

Relational Algebra Expression: Select order number, order date and the purchase amount for each order which will be delivered by a specified  salesman.

Relational Algebra Tree:

Relational Algebra Tree: Select order number, order date and the purchase amount for each order which will be delivered by a specified  salesman.

Explanation:

Syntax of select order number, order date and the purchase amount for each order which will be delivered by a specified  salesman.

Pictorial presentation :

Result of select order number, order date and the purchase amount for each order which will be delivered by a specified salesman

Practice Online


Query Visualization:

Duration:

Query visualization of Select order number, order date and the purchase amount for each order which will be delivered by a specified salesman - Duration

Rows:

Query visualization of Select order number, order date and the purchase amount for each order which will be delivered by a specified salesman - Rows

Cost:

Query visualization of Select order number, order date and the purchase amount for each order which will be delivered by a specified salesman - Cost

 

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

Previous: From the following table, write a SQL query to find those customers whose grade is 200. Return customer_id, cust_name, city, grade, salesman_id.
Next:From the following table, write a SQL query to find the Nobel Prize winner(s) in the year 1970. Return year, subject and winner.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?



SQL: Tips of the Day

Nested select statement in SQL Server.

You need to alias the subquery.

SELECT name FROM (SELECT name FROM agentinformation) a 

or to be more explicit

SELECT a.name FROM (SELECT name FROM agentinformation) a  

Database: SQL Server

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