Write SQL statement that "Questions Are Dependent
to each other":
1- Modifies any customer lives in Egypt to be of name
{Abo Ali}
2- Adds the following data to the customer table
{name=Shmuel Katz, ID=ISKAs, Country = Israel}
3- Deletes any customer from Israel
4- Finds the customer that bought product "Chai"
5- Lists all product names existed in an order requested
from a company "Alfreds Futterkiste"
6- Finds all products categorized as seafood
7- Finds all products from London
8- Finds customers those bought the product Konbu and
didn’t buy the product Tofu
9- Finds the customer with the highest amount of
transactions.
10- Finds all products with unit price higher than the
average unit price of all products.
محتاح حلها في اسرع وقت
