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

Capgemini ADAPT 2022 Toy Rental A Solutions - Learning Outcome 1
Capgemini ADAPT 2022 Toy Rental A Solutions - Learning Outcome 1

The problems of  Toy Rental LO 1 are – Available Toys, Toys based on Age, Customer Ascending Order, and Customer Count. In this post, you will get the solution to the Capgemini ADAPT 2022 solutions to the problems of Toy Rental A Learning Outcome 1.

Note: The solutions are provided for learning purposes only. 

Table of Contents

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


1.TR1-1-Available Toys:


alter session set current_schema = mt_toy;

SET heading OFF

SELECT TOY_ID, TOY_NAME, TOY_TYPE, MIN_AGE, MAX_AGE, PRICE,

QUANTITY, RENTAL_AMOUNT FROM TOY;

2.TR1-2-Toys based on the Age:


alter session set current_schema = mt_toy;
SET heading OFF

SELECT * FROM TOY
WHERE MIN_AGE < 4 OR MAX_AGE < 4;

3.TR1-3-Customer Ascending order:


alter session set current_schema = mt_toy;
SET heading OFF

SELECT * FROM customer

ORDER BY customer_name ASC;

4. TR1-4-Customer Count:


alter session set current_schema = mt_toy;
SET heading OFF

SELECT city, COUNT(*) AS TOTAL

FROM customer 

GROUP BY city;

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


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 
Previous articleMyGov India Janbhagidari Se Sushaasan Maha Quiz Answers 2022 | Cash Rewards
Next articleReliance Off Campus Drive 2022 Hiring Freshers as Junior Software Engineer
Job Seeker 24 provides Off-Campus Drive Updates, Engineering Job Updates, IT Job Updates, Jobs for Freshers, Private Sector Jobs, Public Sector Jobs, various Educational Opportunities, etc.

LEAVE A REPLY

Please enter your comment!
Please enter your name here