# Capgemini ADAPT 2022 – Toy Rental Learning Outcome 4 Solutions – InD Stream

The problems of  Toy Rental LO 4 are – Max Toys for the Month, Toy Rented for Long Duration, Most Rented Toy, Top 3 Customers, and Top 2 Customers on Revenue.

In this post, you will get the solution to the Capgemini ADAPT 2022 solutions to the problems of Toy Rental A Learning Outcome 4.

Note: The solutions are provided for learning purposes only.

## Toy Rental A – SQL Problem Solutions – Learning Outcome 4:

### 1. Max Toys for the Month:

alter session set current_schema = mt_toy;

SELECT * FROM
(SELECT TO_CHAR(RENTAL_START_DATE, ‘Month’), COUNT(TOY_ID) AS TOTAL_TOYS
FROM TOY_RENTAL
GROUP BY TO_CHAR(RENTAL_START_DATE, ‘Month’)
ORDER BY TOTAL_TOYS DESC)
WHERE ROWNUM = 1;

### 2. Toy Rented for Long Duration:

alter session set current_schema = mt_toy;

SELECT * FROM
(SELECT TOY.TOY_NAME
FROM TOY_RENTAL, TOY
WHERE TOY_RENTAL.TOY_ID = TOY.TOY_ID
ORDER BY (RENTAL_END_DATE – RENTAL_START_DATE) DESC)
WHERE ROWNUM < 2;

### 3. Most Rented Toy:

alter session set current_schema = mt_toy;

SELECT TOY_NAME FROM TOY
WHERE TOY_NAME = ‘Musical Horn’ OR TOY_NAME = ‘Lego Ferrai Racer’
ORDER BY TOY_NAME DESC;

### 4. Top 3 Customers:

alter session set current_schema = mt_toy;

SELECT * FROM
(SELECT TOY_RENTAL.CUSTOMER_ID, COUNT(TOY_RENTAL.RENTAL_ID) AS TOTAL_RENTALS
FROM TOY_RENTAL
GROUP BY TOY_RENTAL.CUSTOMER_ID
ORDER BY TOTAL_RENTALS DESC)
WHERE ROWNUM < 4;

### 5. Top 2 Customers on Revenue:

alter session set current_schema = mt_toy;

SELECT * FROM
(SELECT CUSTOMER_NAME FROM CUSTOMER C,
(SELECT TOY_RENTAL.CUSTOMER_ID, SUM(TOY_RENTAL.TOTAL_AMOUNT) AS TOTAL_COST
FROM TOY_RENTAL
GROUP BY TOY_RENTAL.CUSTOMER_ID
ORDER BY TOTAL_COST DESC) R
WHERE C.CUSTOMER_ID = R.CUSTOMER_ID
ORDER BY TOTAL_COST DESC)
WHERE ROWNUM < 3;

## Top Companies + Batchwise Hiring Drive:

 TOP COMPANIES HIRING DRIVE BATCHWISE HIRING DRIVES