Question

1.        Write SQL commands for the following queries (i) to (v)  based on the relations STAFF and SALARY given below:                                                                     5
Id
Name
Dept
Sex
Experience
101
Siddharat
Sales
M
12
104
Raghav
Finance
M
6
107
Naman
Research
M
15
114
Nupur
Sales
F
3
109
Janvi
Finance
F
9
TABLE: SALARY
 
ID
Basic
Allowance
Commission
101
15000
1500
800
104
17000
1200
500
107
16000
1000
200
114
20000
2200
550
109
18000
1000
250
105
15000
1200
150
a)    Display NAME of all the staff who is in SALES having more than 10 year experience from the table staff.
b)    Display the average Basic Salary of all staff working in ”Finance” department using the table staff and salary.
c)    Display the minimum ALLOWANCE of female staff.
d)    Display the number of staff in each department
e)    To display Name and Dept of all the Staffs where experience  between 10 to 15
 ​

Answer 1

Answer:

Require lengthy offline/ batch training. Do not learn incrementally or interactively, in real-time. Poor transfer learning ability, reusability of modules, and integration. Systems are opaque, making them very hard to debug