Question: NEEDED IN MS SQL / MS ACCESS URGENTLY THANKS e give assumptions. ender, Age, DepartmentID) *** Use Site Management database below to write the following
NEEDED IN MS SQL / MS ACCESS URGENTLY THANKS

e give assumptions. ender, Age, DepartmentID) *** Use Site Management database below to write the following SQL queries. Q.4. [12 pts] Retrieve full name (first name and last name concatenated with a blank) of the owner, full name (first name and last name concatenated with a blank) of the renter, flat ID, and area of the flat for the flats that have amounts to be paid (use field Amount ToBePaid in table Sitelncome) more than 49 Turkish Liras and 99 kuru (cent) with the index difference less than 10 in the period 2016-12. Rename the column name for owner and renter as Owner's Name and Renter's Name, respectively. Have your list ordered by flat ID. Keep in mind that some flats may not have renters. Person There are total 150,000 rows. There 40 rows for each page. ge. tudent(Age); PersonlD er='F'; int 1 2 7 8 First Name LastName nvarchar(50) nvarchar(50) Ali AYDIN Hakan YILMAZ Mustafa AAOLU Mahmut NEYZEN Birthdate Email Tel smalldatetime varchar(50) varchar(50) 1970-01-01 ali@aydin.com 0532 787 99 88 1965-01-01 hakan@gmail.com 0542 444 77 88 1974-01-01 agaoglum@gmail.com 0532 222 22 22 1944-01-01 mahmut@outlook.com 0555 666 44 11 n Student(Student ID, Age); e Age>=35 and Age
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
