🔔 Prolifics Off Campus Drive 2021 | 0-2 years | Trainee | BE/ B.Tech/ MCA | Pune/ Hyderabad

Job Title : Trainee
Experience : 0 – 2 years
Job Location : Hyderabad
Educational Qualification : B.Tech/BE/M.Tech/MCA
Package : 3 LPA

https://fresherearth.blogspot.com/2021/08/Prolifics-Off-Campus-Drive-2021-0-2-years-Trainee-BE-B.Tech-MCA-Pune-Hyderabad.html

✅✅Duplicated Products - MapIt (MyAnatomy) Python Solution - Replicon Test Code

https://stupidtechy.me/threads/duplicated-products-mapit-myanatomy-python-solution-replicon-test-code.117/

Duplicate

✅✅Circular Printer - MapIt (MyAnatomy) Python Solution - Replicon Test Code

https://stupidtechy.me/threads/circular-printer-mapit-myanatomy-python-solution-replicon-test-code.116/

🔔 Magnitude Software Off Campus Drive 2021 | Freshers | Associate Software Engineer | Bangalore

* Job Role : Associate Software Engineer
* Education : Engineering
* Experience : Fresher's(0 - 1 Year's)
* Location : Bengaluru, Karnataka, India
* Package : 3 LPA+

https://fresherearth.blogspot.com/2021/08/Magnitude-Software-Off-Campus-Drive-2021-Freshers-Associate-Software-Engineer-Bangalore.html

🎯Tavant Off Campus Drive 2021 | Freshers | Software Engineer | BE/ B.Tech/ MCA | Bangalore/ Hyderabad/ Noida

Job Role : Software Engineer
Qualification : B.E/B.Tech
Experience : Freshers (2021 Batch)
Job Location : Bangalore/ Hyderabad/ Noida
Package : INR 6.5 LPA

https://fresherearth.blogspot.com/2021/08/Tavant-Off-Campus-Drive-2021-Freshers-Software-Engineer-BE-B.Tech-MCA-Bangalore-Hyderabad-Noida.html

🔔Accenture Off Campus Drive 2021 | Direct Hiring | Freshers | B.E. / B. Tech / M.E / M.Tech / MCA / M.Sc | PAN India

*Job Role : Associate Software Engineer
*Qualification : B.E. / B. Tech / M.E / M.Tech / MCA / M.Sc (All streams)
*Experience : Freshers 2019,2020 & 2021 Passout
*Job Location : PAN India Bangalore, Hyderabad, Chennai, Mumbai, Pune, Gurugram
*Salary : 4,50,000 LPA

https://fresherearth.blogspot.com/2021/07/Accenture-Off-Campus-Drive-2021-BE-B.Tech-PAN-India.html

✅ Important - Unmute & Pin this channel in your telegram app to never miss any updates

🔔 Sprinklr Campus Hiring Challenge | Product Engineer | 3.5 LPA+

* Job Role : Product Engineer
* Education : Bachelor's degree
* Batch : 2021, 2022
* Job Location : Bangalore/Gurgaon, India
* Package : 3.5 LPA+

https://fresherearth.blogspot.com/2021/08/sprinklr-campus-hiring-challenge.html

Now correct
That time I just checked one test case😅

Very cool number

🔰 Dunzo Answers

1. select id, name
from student
order by score desc, id asc
limit 3;



2. SELECT IFNULL(customer_name, "N/A") customer_name, IFNULL(product_name, "N/A") product_name, IFNULL(quantity, 0) quantity
FROM ((customer LEFT OUTER JOIN invoice ON customer.id = invoice.customer_id) LEFT OUTER JOIN invoice_item ON invoice_item.invoice_id = invoice.id) LEFT OUTER JOIN product ON invoice_item.product_id = product.id
ORDER BY customer.id, product.id;



3. SELECT
p.product_name,
(COALESCE (SUM(CASE WHEN i.time_paid is null and i.time_canceled is null and i.time_refunded is null IS NOT NULL THEN it.quantity * it.price ELSE 0 END ),0)) as due,
(COALESCE (SUM(CASE WHEN i.time_paid IS NOT NULL THEN it.quantity * it.price ELSE 0 END ),0)) as paid,
(COALESCE (SUM(CASE WHEN i.time_canceled IS NOT NULL THEN it.quantity * it.price ELSE 0 END ),0)) as canceled,
(COALESCE (SUM(CASE WHEN i.time_refunded IS NOT NULL THEN it.quantity * it.price ELSE 0 END ),0)) as refunded
FROM
PRODUCT p
LEFT OUTER JOIN invoice_item it ON p.id = it.product_id
LEFT OUTER JOIN invoice i ON it.invoice_id = i.id
GROUP BY
product_name
ORDER BY
p.id ASC



4. SELECT c.name,
c.phone,
SUM(CASE WHEN h.direction = 'in' THEN h.duration END) as IncomingCost,
SUM(CASE WHEN h.direction = 'out' AND h.duration > 120 THEN 500 + 2*(h.duration-120)
ELSE 2*(h.duration-120)
END) as OutgoingCost,
SUM(CASE WHEN h.direction = 'in' THEN h.duration END +
CASE WHEN h.direction = 'out' AND h.duration > 120 THEN 500 + 2*(h.duration-120)
ELSE 2*(h.duration-120)
END) as TotalCost
FROM customer c
JOIN (SELECT 'out' as directon, duration, dialed_on, outgoing_phone as phone
FROM history
WHERE YEAR(dialed_on) = 1995
AND MONTH(dialed_on) = 1
UNION ALL
SELECT 'in' as direction, duration, dialed_on, incoming_phone as phone
FROM history
WHERE YEAR(dialed_on) = 1995
AND MONTH(dialed_on) = 1
) h ON c.phone = h.phone
GROUP BY c.name,
c.phone



5. select c.company_code, c.founder,
count(distinct l.lead_manager_code), count(distinct s.senior_manager_code),
count(distinct m.manager_code),count(distinct e.employee_code)
from Company c, Lead_Manager l, Senior_Manager s, Manager m, Employee e
where c.company_code = l.company_code
and l.lead_manager_code=s.lead_manager_code
and s.senior_manager_code=m.senior_manager_code
and m.manager_code=e.manager_code
group by c.company_code order by c.company_code;

✅✅✅Paths in a Warehouse - HackerRank

https://stupidtechy.me/threads/paths-in-a-warehouse-hackerrank-python-solution.98/

✅✅✅ Dunzo Answers...

https://stupidtechy.me/forums/sql.32/

What all mnc doing😂😂😂😂😂😂😂😂😂😂😂


Now Capgemini
Last date to register Sep 1, 2021

2021 Batch

https://www.capgemini.com/in-en/careers/pooled-campus-recruitment-drive-for-engineering-and-mca/?utm_source=tpo_mailers&utm_medium=college_campus&utm_campaign=pooledcampus_drive_aug_21

✅✅ The Code Friends - HackerRank

✅✅The Heroes Location - HackerRank Sql question

select id from superhero where latitude<50 and longitude <50;