Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The first three is the database and the rest of the photos are the task. please answer from 1-13 The Questions are from the fourth

image text in transcribedimage text in transcribedThe first three is the database and the rest of the photos are the task. please answer from 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

The Questions are from the fourth photo. Please answer from 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. 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

Databases Demystified

Authors: Andrew Oppel

1st Edition

0072253649, 9780072253641

More Books

Students also viewed these Databases questions

Question

=+2 How does the preparation and support for each type of IE vary?

Answered: 1 week ago

Question

=+What is the extent of the use of each type of IE?

Answered: 1 week ago