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

NEEDED IN MS SQL / MS ACCESS URGENTLY THANKS e give assumptions.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!