Menu
Menu

    LIVE Classes

    EV Programme
    EV Programme New

    IIT Delhi certified

    AI & Machine Learning
    AI & Machine Learning New

    Intel & IIT-M Pravartak Certified

    Data Science
    Data Science

    IIT-M Pravartak certified

    Full Stack Development
    Full Stack Development

    IIT-M Pravartak certified

    UI/UX Design
    UI/UX Design

    HCL GUVI certified

    Mechanical CAD
    Mechanical CAD

    Autodesk & IITM Pravartak Certified

    Courses

    Free Courses

    Free Courses

    Paid Courses

    Paid Courses

    Combo Courses

    Combo Courses

    Practice

    CodeKata

    CodeKata

    Sharpen your coding skills, prepare for interviews

    WebKata

    WebKata

    Build basic frontend & backend development skills

    SQLKata

    SQLKata

    Master SQL concepts in relational database management

    FixTheCode

    FixTheCode

    A series of programs curated by Industry Experts

    IDE - Online Compiler

    IDE - Online Compiler

    Run & test your code in any programming language

    Resources

    Free Resources

    Free Resources

    Referral

    Referral

    Success Stories

    Success Stories

    Blogs

    Blogs

    Learn Hub

    Learn Hub

    Get The App

    Get The App

    Rewards

    Rewards

    Become an Affiliate

    Become an Affiliate

    Leaderboard

    Leaderboard

    What's New?
    Resume Builder

    Resume Builder

    Our Products

    HackerKID

    HackerKID

    Coding classes platform for K-12 children

    GUVI For Corporates

    GUVI For Corporates

    Meet your Hiring & Training Needs

    Placement Preparation

    Placement Preparation

    Ace Up your Aptitude

    Studytonight

    Studytonight

    Free Programming Resources

    Play StoreApp Store
Still Confused?WhatsApp

Welcome to HCL GUVI

Welcome Img

Hey there! Welcome to HCL GUVI—Grab Your Vernacular Imprint—where tech learning is easy, fun, and curated specially for you. Incubated by IIT Madras & IIM Ahmedabad in 2014 and now part of HCL Group, we're making quality tech education accessible to all.

Join 3M+ learners breaking barriers and upskilling for a brighter future. We're here to guide you every step of the way! 🚀

LIVE Classes

Live Class Img

Zen Classes are HCL GUVI's most refined and flagship product—live, expert-led tech programs for beginners and pros. With IITM Pravartak affiliations, master Full-Stack, Data Science, DevOps, UI/UX, and more in multiple languages!

Explore More

Courses

Courses Img

Looking for flexibility? HCL GUVI's 200+ self-paced courses let you learn anytime, anywhere! From free lessons to IIT-M & Autodesk-certified programs, gain in-demand skills in your preferred language.

Explore More

Practice Platforms

Practice Platform Img

Enhance your coding skills with HCL GUVI's Practice Platforms—interactive, structured, and designed to help you master programming effortlessly.

CodeKata:

A structured coding practice platform with 1500+ coding problems designed by industry experts. Ideal for beginners and professionals preparing for tech interviews with real-world coding challenges.

Try Now >

WebKata:

An interactive platform to master HTML, CSS, JavaScript, and Bootstrap with a live coding environment. Perfect for hands-on web development practice without any setup.

Try Now >

SQLKata:

A practice ground for mastering SQL queries used in real-world applications. Write, optimize, and refine your queries to build strong database skills.

Try Now >

FixTheCode:

Hone your bug-fixing skills with real-world debugging challenges in Python, C++, JavaScript, and Golang. More languages coming soon!

Try Now >

IDE:

A free online compiler supporting 20+ programming languages with auto-complete, debugging, and AI-powered code generation—all in the cloud!

Try Now >

Leaderboard

LeaderBoard Img

Climb the leaderboard as you earn Geekoins by learning and practicing! The top scorers get featured, making learning competitive and rewarding. Keep going—you could be next!

Explore More

Rewards

Rewards Img

Earn Geekoins by watching videos and practicing problems, then redeem them for exciting rewards. The more you engage, the more you win!

Explore More

Referral

Referral Img

Love learning with HCL GUVI? Share it with friends! Invite them using your unique link or code and unlock exciting rewards—Amazon vouchers, iPhones, and more. A Win-Win.

Explore More

Profile

Profile Img

Your HCL GUVI profile is your digital portfolio! Track progress, showcase skills, add projects, and build a resume. Keep it updated—opportunities await!

Explore More

That's It! You Are Ready!

Finish Img

You're all set to dive into your learning journey with HCL GUVI. Explore, upskill, and make each step count—exciting possibilities awaits!

Thank you for Reaching us out

Our team will reach you out
within the next 24 hours.

Explore all Programs
SQLKATA AquaFresh Bottled Water Distribution
AquaFresh Bottled Water Distribution

Completed

Incomplete

Not Attended

Share

AquaFresh monitors all bottled water shipments across multiple cities. The Supply
Chain Analyst is responsible for tracking high-volume shipments, summarizing total bottles
delivered per city, and identifying major shipments for planning and logistics. The database
records shipment ID, distributor name, bottle size (in liters), quantity, and city. Your role is to
write SQL queries to helping the management optimize.

notAttendedQuestion - 1

List shipments with quantity above 500.

notAttendedQuestion - 2

Calculate total bottles distributed per city.

Prev
View Questions
Next
Code Editor
Table Name: water_shipments
shipment_id distributor_name bottle_size_l quantity city
1 Kabir Khan 1.0 600 Delhi
2 Nisha Singh 0.5 400 Mumbai
3 Rohan Verma 1.5 750 Delhi
4 Isha Patel 2.0 300 Bangalore
5 Arjun Das 1.0 800 Mumbai

>>> Submit Your Query to validate
geek

Awesome!

To save your progress Please Login or Register

geek

Ohho, Almost There!

Your code has failed one or more test cases. Please try again to complete it.

geek

Hurray! You did it!

You have successfully completed this SQLKATA Exercises. Proceed to the next one.

geek

Congratulation

You have successfully completed the SQLKATA Exercises

geek

+0 Points

You have earned 0 Geekoins. You can use this Geekoins to redeem rewards.