Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Here is a clearer photo of the databse The first three photos are the database and the rest is the task(1-13) 1. Fetoh alphabeticaliy last
Here is a clearer photo of the databseThe first three photos are the database and the rest is the task(1-13)
1. Fetoh alphabeticaliy last naine of che last person fron turku. Nesult must be like thist last Virta 2. Hor many different degrees there art in person tablet Set header as count. 3. What in the reason for following querien to end up in different reaulta? select avg thouring glansed from frol perw 4. Fetch all the persons, forn a single atring fron first name and nalaky 1ike 'Jukko 2.bk'. That seana Jukkas salary in kiloeuros rounded to one decimal. Sort descending by salary. Result shoutd be like this; selary? Mako 3.1k. Radi 3.1k lukka 3.Ok Jukika 28 : 5. Moke a query that showe rencal car'a pickup date thoan datel as the current date funing sot. functont and auronaticady calcutates retare dace at peo deya fron current date, the reaialt, should look ifke this fike inithere: finan itatti Yhcurn datel 6. Moke o sane guery at in 5 Eat nhow the wexdaye inatead of daterHebult ibould 1ook tike this ifor the dates abovel. loan_date return,date Tuestey Thursdey 7. Counc the sun of salaries for each oity; (eity, total salary) e. How way projects are on each location? Tetch location and seunc yith alias naned "tetal". 9. Count personst tanes with anlary and cax.percontage. Colunns are soesecte, Inane, fname, salary, caxpere and tax, fort by tax deacenting. 10. What is the ditference between minjaus and maximun salartes and how nuch biqger in the eaxinum salary than the atnimun salafy in percentaje. 11. Tetch nased and satarias of those people whose salary would te bver 3000 after 104 incteane in alary. 17. Teceh nanes, satartes and difference to maximun salary in percentage. 13. Make a query that returns following data. Count the average hours done to each project per person and the average cost per person in eurosi: The hourly cost is project d s number tines ten. With Pl it's 10e/h, P2 20g/h and so on. Found the resulta to integer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started