CBSE 2025, Set 4

Question

Suman has created a table named **WORKER** with a set of records to maintain the data of the construction sites, which consists of **WID**, **WNAME**, **WAGE**, **HOURS**, **TYPE**, and **SITEID**. After creating the table, she entered data in it, which is as follows :

![Table WORKER](https://media.edvaya.com/wp-content/uploads/cbse-2025-set-4-q32-table-worker.webp)

**(a)** Based on the data given above, answer the following questions :
**(i)** Write the SQL statement to display the names and wages of those workers whose wages are between 800 and 1500.
**(ii)** Write the SQL statement to display the record of workers whose **SITEID** is not known.
**(iii)** Write the SQL statement to display **WNAME**, **WAGE** and **HOURS** of all those workers whose **TYPE** is 'Skilled'.
**(iv)** Write the SQL statement to change the **WAGE** to 1200 of the workers where the **TYPE** is "Semiskilled".

**OR**

**(b)** Considering the above given table **WORKER**, write the output on execution of the following SQL commands :
**(i)** `SELECT WNAME, WAGE*HOURS FROM WORKER WHERE SITEID = 103;`
**(ii)** `SELECT COUNT(DISTINCT TYPE) FROM WORKER;`
**(iii)** `SELECT MAX(WAGE), MIN(WAGE), TYPE FROM WORKER GROUP BY TYPE;`
**(iv)** `SELECT WNAME, SITEID FROM WORKER WHERE TYPE="Unskilled" ORDER BY HOURS;`

Edvaya · Accepted Answer

The correct answer is Subjective. Here are the solutions for both parts: ### Part (a) - SQL Statements: **(i)** Display names and wages for wages between 800 and 1500: ```sql SELECT WNAME, WAGE FROM WORKER WHERE WAGE BETWEEN 800 AND 1500; ``` *(Alternatively: `WHERE WAGE >= 800 AND WAGE <= 1500;`)* **(ii)** Display records where SITEID is unknown: ```sql SELECT * FROM WORKER WHERE SITEID IS NULL; ``` **(iii)** Display WNAME, WAGE, HOURS for 'Skilled' workers: ```sql SELECT WNAME, WAGE, HOURS FROM WORKER WHERE TYPE = 'Skilled'; ``` **(iv)** Update WAGE to 1200 for 'Semiskilled' workers: ```sql UPDATE WORKER SET WAGE = 1200 WHERE TYPE = 'Semiskilled'; ``` --- ### OR ### Part (b) - SQL Outputs: **(i)** Multiplies `WAGE` by `HOURS` for workers at `SITEID = 103` (Ahmed J and Anju S): ```text WNAME | WAGE*HOURS ----------+------------ Ahmed J | 300000 Anju S | 156000 ``` **(ii)** Counts the unique values in the `TYPE` column (Unskilled, Skilled, Semiskilled): ```text COUNT(DISTINCT TYPE) ---------------------- 3 ``` **(iii)** Finds the maximum and minimum wages, grouped by each `TYPE`: ```text MAX(WAGE) | MIN(WAGE) | TYPE -----------+-----------+------------- 1500 | 780 | Unskilled 1200 | 520 | Skilled 560 | 560 | Semiskilled ``` **(iv)** Retrieves `WNAME` and `SITEID` for 'Unskilled' workers, sorted ascending by `HOURS` (Jacob B: 95 hours, Ahmed J: 200 hours): ```text WNAME | SITEID ----------+-------- Jacob B | 101 Ahmed J | 103 ```

Edvaya Target

Edvaya Aspire

Take a Free Mock Test

Target Subjects

Aspire Subjects

Subject Mastery

Computer Science > Database Management > Structured Query Language

Keep Practicing

Current Question

Community Stats

Track Your Progress

Edvaya Target

We Value Your Privacy