In this post, we have tried to provide solutions to the problems of Capgemini ADAPT 2022 Book Rental A (Month Maximum Books Rented, Book Rented for Maximum Duration, Book Availed by most of the customers, Top 2 users by Revenue). These problems are from Capgemini ADAPT Program 2022. We have provided the solutions to the Problems noted below –
- BRL4-1 Month Maximum Books Rented
- BRL4-2 Book Rented for Maximum Duration
- BRL4-3 Book Availed by most of the customers
- BRL4-4 Top 2 users by Revenue
Note: The solutions are provided for your reference only. During the assessment, you are requested to not use any malpractices, rather than solve all the problems on your own. We do not encourage candidates to fall into any malpractice.
Table of Contents
- Book Rental A Problem Solutions:
- Top Companies + Batchwise Hiring Drive:
- To Stay Up-to-date, Follow us on Social Media:
- ADAPT Different Coding Solutions:
- Capgemini ADAPT Sprint 1 (Bus Reservation Solutions):
- Capgemini ADAPT Sprint 2 (Bus Reservation System):
- ADAPT Sprint 3 Solutions – Capgemini (Toy Rental A):
- Online Shopping A Solutions Using Java:
Book Rental A Problem Solutions:
1.BRL4-1 Month Maximum Books Rented Problem Solution:
Display the month and the number of books when the maximum number of books were rented.
Solution:
alter session set current_schema = bookrental;
SET heading OFF
SELECT * FROM
(SELECT TO_CHAR (RENTAL_START_DATE, ‘Month’)
AS MONTH, COUNT (book_id) AS TOTAL_BOOKS
FROM BOOK_RENTAL
GROUP BY TO_CHAR(RENTAL_START_DATE, ‘Month’)
ORDER BY TOTAL_BOOKS DESC)
WHERE ROWNUM = 1;
2. BRL4-2 Book Rented for Maximum Duration Problem Solution:
Fetch the book’s title which was on rent for maximum duration.
Solution:
alter session set current_schema = bookrental;
SET heading OFF
SELECT title
FROM book
WHERE book_id in (SELECT book_id
FROM book_rental
WHERE (months_between (rental_start_date, rental_end_date) =
(SELECT max (months_between(rental_start_date, rental_end_date))
FROM book_rental )));
3. BRL4-3 Book Availed by most of the customer’s Problem Solution:
Fetch the book’s title which was availed for rent by most of the users.
Solution:
alter session set current_schema = bookrental;
SET heading OFF
SELECT title
FROM book
WHERE book_id in (
SELECT book_id
FROM book_rental HAVING count(*) =
(SELECT max(count(*))
FROM book_rental
GROUP BY book_id)
GROUP BY book_id);
4. BRL4-5 Top 2 users by Revenue Problem Solution:
Identify the top 2 preferred users in descending order of max revenue generated.
Solution:
alter session set current_schema = bookrental;
SET heading OFF
select * from
(select ud.first_name
from user_details ud, book_rental br
where ud.user_id = br.user_id
group by ud.first_name
order by sum(total_amount) desc)
where rownum < 3;
BOOK RENTAL A ALL SOLUTIONS | CLICK HERE |
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:
- Largest Array Solution – Click Here
- Batsman & Bowler Solution – Click Here
- Instruments Problem Solution – Click Here
- Check Two Person Are Same – Click Here
- Medicine App ADAPT Solution – Click Here
- String Combination Capgemini ADAPT Solution – Click Here
- Remove”X”inString Problem Solution – Click Here
- Customer and Invoice ADAPT Problem Solution – Click Here
- Book and Author Problem Solution – Click Here
- Highest Feedback Problem Solution – Click Here
- Registered Customer Problem Solution in Java – Click Here
- Product of Digits Problem Solution – Click Here
- 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):
- 1. Capgemini Adapt 2022 Toy Rental A Solutions for Sprint 3 Learning Outcome 1
- 2. Capgemini Adapt 2022 Toy Rental A Solutions for Sprint 3 Learning Outcome 2
- 3. Capgemini Adapt 2022 Toy Rental A Solutions for Sprint 3 Learning Outcome 3
- 4. Capgemini Adapt 2022 Toy Rental A Solutions for Sprint 3 Learning Outcome 4
Online Shopping A Solutions Using Java:
- 1. Capgemini ADAPT 2022 Online Shopping A – Display Products Solution using JAVA – Click Here
- 2. Capgemini ADAPT 2022 Online Shopping A – Products by Category Solution using JAVA – Click Here
- 3. Capgemini ADAPT 2022 Online Shopping A – Customer Array Solution using JAVA – Click Here
- 4. Capgemini ADAPT 2022 Online Shopping A – Search Customers by Name Solution using JAVA – Click Here
- 5. Capgemini ADAPT 2022 Online Shopping A – Search Customers by City Solution using JAVA – Click Here
- 6. Online Shopping A – Customer & Address Class Solution | Capgemini ADAPT 2022 Solutions – Click Here