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 23 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 23 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!