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

By
Minhaj
-
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 DRIVE BATCHWISE HIRING DRIVES
1. TCS OFF-CAMPUS DRIVES 1. 2018 BATCH
2. INFOSYS OFF-CAMPUS DRIVES 2. 2019 BATCH
3. COGNIZANT OFF-CAMPUS DRIVES 3. 2020 BATCH
4. WIPRO OFF-CAMPUS DRIVES 4. 2021 BATCH
5. CAPGEMINI OFF-CAMPUS DRIVES 5. 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 

RELATED ARTICLESMORE FROM AUTHOR