Answered step by step
Verified Expert Solution
Link Copied!

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 databseimage text in transcribedimage text in transcribedThe first three photos are the database and the rest is the task(1-13)

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 25th European Conference Adbis 2021 Tartu Estonia August 24 26 2021 Proceedings Lncs 12843

Authors: Ladjel Bellatreche ,Marlon Dumas ,Panagiotis Karras ,Raimundas Matulevicius

1st Edition

3030824713, 978-3030824716

More Books

Students also viewed these Databases questions

Question

Choose an appropriate organizational pattern for your speech

Answered: 1 week ago

Question

Writing a Strong Conclusion

Answered: 1 week ago