Capgemini ADAPT 2022 – Toy Rental A (Based on Rental, Based on Price Quantity, Based on Quantity) Solutions

The problems of  Toy Rental LO 2 are – Toys based on Rental, Toys based on Price Quantity, and Toys based on Quantity. In this post, you will get the solution to the Capgemini ADAPT 2022 solutions to the problems of Toy Rental A Learning Outcome 2.

Note: The solutions are provided for learning purposes only. 

Toy Rental A – SQL Problem Solutions – Learning Outcome 2:

---

1. Toys Based on Rental:

---

alter session set current_schema = mt_toy;
SET heading OFF

SELECT CUSTOMER_NAME
FROM CUSTOMER C, (SELECT CUSTOMER_ID, COUNT(CUSTOMER_ID) FROM TOY_RENTAL R
GROUP BY CUSTOMER_ID
HAVING COUNT(CUSTOMER_ID) > 2) R
WHERE C.CUSTOMER_ID = R.CUSTOMER_ID AND ROWNUM < 3;

2. Toys Based on Price Quantity:

---

alter session set current_schema = mt_toy;
SET heading OFF

SELECT * FROM TOY
WHERE PRICE > 145 AND QUANTITY = 5;

3. Toys Based on Quantity:

---

alter session set current_schema = mt_toy;
SET heading OFF

SELECT * FROM TOY
WHERE QUANTITY BETWEEN 20 AND 50;

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):

---

• 1. Capgemini ADAPT Sprint 1 Bus Reservation System – DisplayCustomerInAscendingOrder Problem Solution
• 2. Capgemini ADAPT Sprint 1 Bus Reservation System – DisplayCustomerByFirstName Problem Solution
• 3. Capgemini ADAPT Sprint 1 Bus Reservation System – SortByCustomerId Problem Solution
• 4. Capgemini ADAPT Sprint 1 Solution Java | LSAByCustomerName Problem Solution
• 5. Capgemini ADAPT Sprint 1 Case Study Solution Java | BSAByCustomerId Problem Solution

Capgemini ADAPT Sprint 2 (Bus Reservation System):

---

• 1. Capgemini ADAPT Sprint 2 Case Study (Bus Reservation System) Solution | HAS-A-Relationship Solution Java
• 2. Capgemini ADAPT Sprint 2 Case Study (Bus Reservation System) Solution OOPs-Para-Constructor Java
• 3. Capgemini ADAPT Sprint 2 Bus Reservation System (CRUDOperations) Problem Solution

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

---

• Capgemini Adapt 2022 Toy Rental A Solutions for Sprint 3 Learning Outcome 1

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