Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Write the output of the given program:
Give column headings as Item Name, Quantity, Price.
Make sure to read first row as data and not as column headers.
(UPDATE, SELECT, ALTER, DROP)
TABLE: SALESPERSON
| CODE | NAME | SALARY | ITCODE |
| 1001 | TANDEEP JHA | 60000 | I2 |
| 1002 | YOGRAJ SINHA | 70000 | I5 |
| 1003 | TENZIN JACK | 45000 | I2 |
| 1005 | ANOKHI RAJ | 50000 | I7 |
| 1004 | TARANA SEN | 55000 | I7 |
TABLE: ITEM
| ITCODE | ITEMTYPE | TURNOVER |
| I5 | STATIONARY | 3400000 |
| I7 | HOISTERY | 6500000 |
| I2 | BAKERY | 10090000 |
(a) To display the CODE and NAME of all salesperson having “I7” item Type Code from the table SALESPERSON.
(b) To display all details from table SALESPERSON in descending order of SALARY.
(c) To display the number of SALESPERSON dealing in each TYPE of ITEM.(Use ITCODE for the same)
(d) To display NAME of all the salesperson table along with their corresponding ITEMTYPE from the ITEM table.
(e) Select max(salary) from salesperson;
(f) Select distinct itcode from salesperson;
(g) select code,name,i.itcode from sales persons, item i where s.itcode=i.itcode and turnover>=7000000;
(h) Select sum (salary)from salesperson where itcode=”i2”;