Q1/ Consider the fruit database with fruit and market tables, where the primary keys are underlined. Give an expression in SQL for each of the following queries. Fruit(ID, fruit_name, fruit_color,...

NoneQ1/ Consider the fruit database with fruit and market tables,<br>where the primary keys are underlined. Give an expression in<br>SQL for each of the following queries.<br>Fruit(ID, fruit_name, fruit_color, price_KG)<br>Market(market name, city, street, fruit_name)<br>1- find the names of red fruits that found in Glasgow market<br>and not found in mart market<br>2- find color, and the market of apple fruits that can be found<br>in the street

Extracted text: Q1/ Consider the fruit database with fruit and market tables, where the primary keys are underlined. Give an expression in SQL for each of the following queries. Fruit(ID, fruit_name, fruit_color, price_KG) Market(market name, city, street, fruit_name) 1- find the names of red fruits that found in Glasgow market and not found in mart market 2- find color, and the market of apple fruits that can be found in the street "west barny" and its price less than 2500. 3- delete the Fruit table from the database. 4- Insert a new record in Market table.

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here