w3resource
Run SQL Query

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?



Share this Tutorial / Exercise on : Facebook and Twitter

SQL: Tips of the Day

Can a foreign key be NULL and/or duplicate?

First remember a Foreign key simply requires that the value in that field must exist first in a different table (the parent table). That is all an Foreign key is by definition. Null by definition is not a value. Null means that we do not yet know what the value is.

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