Menu
Menu

    LIVE Classes

    Software Development
    Software Development New

    MongoDB & IIT-M Pravartak 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

    Debugging

    Debugging

    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

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 >

Debugging:

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 City Library
City Library

Completed

Incomplete

Not Attended

Share

City Library has a large collection of books and manages memberships for readers. You handle the library’s catalog and member records.

notAttendedQuestion - 1

Display all books available at City Library.

notAttendedQuestion - 2

Update the available copies of 'To Kill a Mockingbird' after 2 more copies arrive.

notAttendedQuestion - 3

Add a new book 'Moby Dick' by Herman Melville, published in 1851 with 8 copies.

notAttendedQuestion - 4

Find the most recent book title added to the library.

notAttendedQuestion - 5

Calculate the total number of available copies of all books.

Prev
View Questions
Next
Code Editor
Table Name: books
id title author genre publication_year available_copies
1 The Great Gatsby F. Scott Fitzgerald Fiction 1925 5
2 To Kill a Mockingbird Harper Lee Fiction 1960 3
3 1984 George Orwell Dystopian 1949 10

>>> 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.

Gift IconUnlock Your Exclusive Rewards!

You have exclusive rewards which you can unlock by earning Geekoins. Explore your rewards now!

Explore Rewards