Page 1 of 1
a) Write a SQL query that returns supplier number and purchase price from the SUPPLIES relation for product number 0474.
Posted: Mon Jun 06, 2022 2:02 pm
by answerhappygod

- A Write A Sql Query That Returns Supplier Number And Purchase Price From The Supplies Relation For Product Number 0474 1 (15.98 KiB) Viewed 25 times

- A Write A Sql Query That Returns Supplier Number And Purchase Price From The Supplies Relation For Product Number 0474 2 (27.6 KiB) Viewed 25 times
a) Write a SQL query that returns supplier number and purchase price from the SUPPLIES relation for product number 0474. b) Write an SQL query to return the supplier name and supplier status from the SUPPLIER relation when supplier status is greater than or equal to 75.
Using: wine (sql) Write your
statement below and press "Run" to see the result. select from SUPPLIER 2 Select supplier_name, supplier_status 3 from SUPPLIER 4 where product_number=0474 I