Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
In a Database- SAMS and VENDOR are two tables with the following information. Write MYSQL queries for (i) to (tii), based on tables SAMS and VENDOR : (CBSE OD 2014) Table :SAMS Table : VENDOR ICode IName Price Colour VCode VCode VNAME SO01 Refrigerator 20000 Blue P01 PO1 Satish S002 Mobile Phone 45000 Black P02 PO2 Manoj S003 LCD 60000 Silver P03 PO3 Subodh 5004 Washing Machine 12500 Smoke 16000 White PO1 PO4 Jacob S005 Air conditioner P03 () To display 1Code, IName and VName of all the vendors, who manufacture "Refrigerator". (ii) To display IName, ICode, VName and Price of all the products whose price is more than 2000 (ii) To display vendor names and names of all items manufactured by vendor whose code is "Pos

In a Database- SAMS and VENDOR are two tables with the following information. Write MYSQL queries for (i) to (tii), based on tables SAMS and VENDOR : (CBSE OD 2014) Table :SAMS Table : VENDOR ICode IName Price Colour VCode VCode VNAME SO01 Refrigerator 20000 Blue P01 PO1 Satish S002 Mobile Phone 45000 Black P02 PO2 Manoj S003 LCD 60000 Silver P03 PO3 Subodh 5004 Washing Machine 12500 Smoke 16000 White PO1 PO4 Jacob S005 Air conditioner P03 () To display 1Code, IName and VName of all the vendors, who manufacture "Refrigerator". (ii) To display IName, ICode, VName and Price of all the products whose price is more than 2000 (ii) To display vendor names and names of all items manufactured by vendor whose code is "Pos

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
In a Database - SAMS and VENDOR are trwo tables twith the following information. Write MYSQL queries for (i) to (i), based om tables SAMS and VENDOR : (CBSE OD 2014) Table :SAMS Table : VENDOR ICode IName Price Colour VCode VCode VNAME S001 Refrigerator 20000 Blue P01 POI Satish SO02 Mobile Phone 45000 Black P02 PO2 Manoj SO03 LCD 60000 Silver P03 PO3 Subodh S004 Washing Machine 12500 Smoke 16000 White P01 PO4 Jacob S005 Air conditioner P03 (i) To display 1Code, IName and VName of all the vendors, who manufacture "Refrigerator". (1) To display IName, ICode, VName and Price of all the products whose price is more than 20000 (if) To display bendor names and names of all items manufactured by zendor whose code is "POs
Transcribed Image Text:In a Database - SAMS and VENDOR are trwo tables twith the following information. Write MYSQL queries for (i) to (i), based om tables SAMS and VENDOR : (CBSE OD 2014) Table :SAMS Table : VENDOR ICode IName Price Colour VCode VCode VNAME S001 Refrigerator 20000 Blue P01 POI Satish SO02 Mobile Phone 45000 Black P02 PO2 Manoj SO03 LCD 60000 Silver P03 PO3 Subodh S004 Washing Machine 12500 Smoke 16000 White P01 PO4 Jacob S005 Air conditioner P03 (i) To display 1Code, IName and VName of all the vendors, who manufacture "Refrigerator". (1) To display IName, ICode, VName and Price of all the products whose price is more than 20000 (if) To display bendor names and names of all items manufactured by zendor whose code is "POs
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS