Question

Consider the following three tables, primary and foreign keys.

Table Name       

SalesPeople

Attribute Name                                Type                                      Key Type

EmployeeNumber              Number                               Primary Key

Name                                   Character

JobTitle                                  Character           

Address                                 Character

PhoneNumber                    Character

YearsInPosition                Number

Table Name        ProductDescription

Attribute Name                                 Type                                      Key Type

                ProductNumber                  Number                               Primary Key

                ProductName                    Character           

                ProductPrice                      Number

Table Name        SalesOrder

Attribute Name                                Type                                      Key Type

                SalesOrderNumber         Number                               Primary Key

                ProductNumber              Number                               Foreign Key

                EmployeeNumber           Number                               Foreign Key

                SalesOrderDate                Date

Assume that you draw up a new sales order for each product sold.

Develop the following queries in SQL:

a.       All the Sales People with more than five years in position. (3 pts)

b.      All the Products that cost more than $50. (3 pts)

c.       All the Sales Orders sold by Sales People less than 3 years in the position. (3 pts)

Answer 1

a) solu h'on poswon who have sold product nuuM be ว "67 select nme Fro Sales people c sales ondes podud numbe γ Iunei 3cn sales orde on sales de Employee usheve e q γ sit position c3 and sales dud numbes 163,

seledda numbe , prodesct naume from Prcduch Descrtpion ohere prolul neme dike 7.braded r df moye than 533. seledt sales ondes numeprccluetneme, Prcdud prit e innes oin sees ode on procdue desipton Son sales on seules oydler, Empleyee Nuvsbeya scudes people. Employee muudeγ where ρ,edud-