Delivery Partner details based on rating
Write a query to display partner id, partner name, phone number of delivery partners whose rating is between 3 to 5, sort the result based on partner id.
(Hint: Use Delivery_partners table to retrieve records.)
NOTE: Maintain the same sequence of column order, as specified in the question description
Solution:
SELECT PARTNER_ID, PARTNER_NAME,PHONE_NO FROM DELIVERY_PARTNERS WHERE RATING BETWEEN 3 AND 5 ORDER BY PARTNER_ID;
