Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
3.7k views
in Computer by (79.4k points)

On the basis of the Table Pharma; write the output(s) produced by executing the following queries :

(i) SELECT RXID, DrugName, Price from PharmaDB rvhere PharmacyName IN ('Rx Parmacy", "Raj Medicos");

(ii) SELECT PharmacyName, COUNT(*) FROM PharmaDB GROUP BY PHARMACY NAME;

1 Answer

+1 vote
by (76.4k points)
selected by
 
Best answer

(i)

RxID DrugName Price
R1000 Amlodipine 100.00
R1001 Paracetamol 15.00
R1004 Levocitrezine 110.00

(ii) 

PharmacyName COUNT(*)
Rx Pharmacy 2
Raj Medicos 1
My Chemist 2

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...