Answer Happy

The tables (Figure 1) Salesperson,
Product and Sales show list of
salesperson details, product details and sales details. The
quantity in Sales table gives the number of
products sold by each salesperson. Answer the following
questions.
SALESPERSON
salesPerson
No
salesPerson
Name
Commision %
hireDate
S101
Gaffer
10
15-May-2014
S102
Carter
15
01-Jan-2013
S103
Allen
10
03-Aug-2015
S104
Smith
20
10-Sep-2014
S105
Lewis
15
10-Jan-2015
PRODUCT
productNo
productName
unitPrice
P13425
Hammer
45.00
P21346
Wrench
36.00
P12347
Saw
70.00
P25634
Drill
245.00
P29556
Pliers
134.00
SALES
salesPersonNo
productNo
quantity
S101
P21346
473
S101
P25634
170
S101
P29556
688
S102
P13425
1750
S102
P12347
245
S102
P21346
900
S102
P25634
270
Figure 1: Sales Database
Refer figure 1 from QUESTION 2 to answer the following
questions.
Ans SELECT
salesPersonName,hireDate
FROM
SALESPERSON;
(3
marks)
(4
marks)
Ans;
(4
marks)