Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write SQL code to find the following information for the given tables: tblProvince tbiShop ShoKey ShoName 1 Prold tblWages WagPay WagYear ShoKey EmpKey tblEmployee EmpKey

Write SQL code to find the following information for the given tables:
image text in transcribed
image text in transcribed
tblProvince tbiShop ShoKey ShoName 1 Prold tblWages WagPay WagYear ShoKey EmpKey tblEmployee EmpKey EmpGiven Name EmpSur Name EmpPartner ProId EmpLast Visit ProName ProTax Rate N These tables are from Kihlman's SQL website, Where tolshop is the company table, tbl wages is the salary table, tbl Endoyee correspares Cpeople) and 451 Province corresponds to ovince corresponds to faxes.. a) Find all salaries paid to person ids in the year 2001. The list should include company name and salary. b) the tax authority wants a list of all people working for a company that is called Bling Bling. The list should only in elude the person identity numbers. Get the last names of all people and the company ID that in the year 2001 worked for the come ad for the company called Tax no more

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

Visual Basic 4 Ole Database And Controls Superbible

Authors: Michael Hatmaker, C. Woody Butler, Ibrahim Malluf, Bill Potter

1st Edition

1571690077, 978-1571690074

More Books

Students also viewed these Databases questions

Question

5-8 What are the advantages and disadvantages of the BYOD movement?

Answered: 1 week ago