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

Capgemini ADAPT 2022 - Toy Rental Learning Outcome 4 Solutions - InD Stream
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;
SET heading OFF

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;
SET heading OFF

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;
SET heading OFF

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;
SET heading OFF

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;
SET heading OFF

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 DRIVEBATCHWISE HIRING DRIVES
1. TCS OFF-CAMPUS DRIVES1. 2018 BATCH
2. INFOSYS OFF-CAMPUS DRIVES2. 2019 BATCH
3. COGNIZANT OFF-CAMPUS DRIVES3. 2020 BATCH
4. WIPRO OFF-CAMPUS DRIVES4. 2021 BATCH
5. CAPGEMINI OFF-CAMPUS DRIVES5. 2022 BATCH

To Stay Up-to-date, Follow us on Social Media:


1.      Join our Telegram Channel:Click Here
2.      Like us on Facebook:Click Here
3.      Follow us on Instagram:Click Here
4.      Follow us on LinkedIn:Click Here
5.      Follow us on Google News: Click Here

ADAPT Different Coding Solutions:


  1. Largest Array Solution – Click Here
  2. Batsman & Bowler Solution – Click Here
  3. Instruments Problem Solution – Click Here
  4. Check Two Person Are Same – Click Here
  5. Medicine App ADAPT Solution – Click Here
  6. String Combination Capgemini ADAPT Solution – Click Here
  7. Remove”X”inString Problem Solution – Click Here
  8. Customer and Invoice ADAPT Problem Solution – Click Here
  9. Book and Author Problem Solution – Click Here
  10. Highest Feedback Problem Solution – Click Here
  11. Registered Customer Problem Solution in Java – Click Here
  12. Product of Digits Problem Solution – Click Here
  13. Change Using Minimal Coins/Notes Solution in Java – Click Here

Capgemini ADAPT Sprint 1 (Bus Reservation Solutions):


Capgemini ADAPT Sprint 2 (Bus Reservation System):


ADAPT Sprint 3 Solutions – Capgemini (Toy Rental A):


Study Materials for Interview Preparation (FREE MATERIALS):


  1. 240 Core Java Questions & Answers with PDF Download Link – Click Here
  2. 230+ SQL interview questions & answers pdf download – Click Here
  3. 50 LeetCode Interview Questions with Answers – PDF Notes – Click Here