Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

SQL Exercises: Display the item name, price, and company name of all the products

SQL JOINS: Exercise-22 with Solution

Write a SQL query to display the item name, price, and company name of all the products.

Sample table: company_mast


Sample table: item_mast


Sample Solution:

SELECT item_mast.pro_name, pro_price, company_mast.com_name
   FROM item_mast 
     INNER JOIN company_mast
        ON item_mast.pro_com = company_mast.com_id;

Output of the Query:

pro_name		pro_price	com_name
Mother Board		3200.00		Asus
Key Board		450.00		Frontech
ZIP drive		250.00		Zebronics
Speaker			550.00		Frontech
Monitor			5000.00		Samsung
DVD drive		900.00		iBall
CD drive		800.00		iBall
Printer			2600.00		Epsion
Refill cartridge	350.00		Epsion
Mouse			250.00		iBall

Relational Algebra Expression:

Relational Algebra Expression: Display the item name, price, and company name of all the products.

Relational Algebra Tree:

Relational Algebra Tree: Display the item name, price, and company name of all the products.

Practice Online


Query Visualization:

Duration:

Query visualization of Display the item name, price, and company name of all the products - Duration

Rows:

Query visualization of Display the item name, price, and company name of all the products - Rows

Cost:

Query visualization of Display the item name, price, and company name of all the products - Cost

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

Previous: From the following tables write a SQL query to select all rows from both participating tables as long as there is a match between pro_com and com_id.
Next: From the following tables write a SQL query to calculate the average price of items of each company. Return average value and company name.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?



SQL: Tips of the Day

SQL Server SELECT into existing table. 

INSERT INTO dbo.TABLETWO
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO
  (col1, col2)
SELECT col1, col2
  FROM dbo.TABLEONE
 WHERE col3 LIKE @search_key

Database: SQL Server

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