Answer Happy

1. Give an expression in SQL for each of the following queries. You need to provide the answer in accordance with the provided template. a. Find the e-mail addresses of the female drivers with a rating greater than who own black car and entered three contact numbers in the system to be notified. SELECT e-mail 2/4 FROM User U, UserDriver UD, PeopleToBeNotified PN Where ... AND PN.Phone1 IS NOT NULL AND PN.Phone2 IS NOT NULL AND PN.Phone3 IS NOT NULL b. Find the users (name and surname) who have invited at least three friends to the system. SELECT U.NAME, U.SURNAME FROM ( *** FROM INVITEDFRIENDS FR GROUP BY HAVING COUNT... )... USER AS U... C. Find the users (name, surname, email) who own red and posted a travel plan from Ankara to İstanbul between 24.04.2022-04.05.2022, and have 100 eco points. SELECT Name, Surname, e-mail FROM USER U, USERDRIVER UD, TRAVELPLAN TP AND U.TCNumber= UD.TCNumber AND... 2. Give an expression in relational algebra for each of the following queries. You need to provide the answer in accordance with the provided template. a) Find the drivers (name) who have a rating less than 3 and travelled from İstanbul to Ankara. T1← Travell (Departure-Istanbul Destination-Ankara (TravelPlan)) T2← PTCNumber (Posted By (Departure-Istanbul, Destination-Ankara (TravelPlan))) *** b) Find the user (name) with the highest rating who travelled only as a passenger and commented on at least three users. T1(TCNumber User)-(TCNumber UserDriver) 2 ::