• Skip to primary navigation
  • Skip to content
  • Skip to footer
Thomas Ngo Thomas Ngo Crafting Elegant Solutions Through Code
  • Home
  • Journal
  • Tags
  • About

    Thomas Ngo

    Software Engineer

    • Stanton, California
    • Email
    • GitHub
    • Resume

    SQL problem - Not Boring Movies

    February 9, 2024 less than 1 minute read

    Page Navigation

    • Problem
    • My Query
    • Editorial Solution
    1 min read 106 words

    Problem

    problem-620

    My Query

    SELECT *
    FROM Cinema AS c
    WHERE c.id % 2 != 0 AND c.description != 'boring'
    ORDER BY rating DESC
    

    Editorial Solution

    select *
    from cinema
    where mod(id, 2) = 1 and description != 'boring'
    order by rating DESC
    ;
    

    Tags: SQL

    Updated: February 9, 2024

    Share on

    X Facebook LinkedIn Bluesky
    Previous Next

    Leave a comment

    You may also enjoy

    Elevating Your .NET Career: A Roadmap from Mid-Level to Senior Developer

    3 minute read

    Ready to move beyond CRUD apps? Explore the advanced C# features and architectural patterns you need to master to build robust, scalable, and high-performanc...

    Building a Todo List App with ReactJS and .NET 10 from Scratch

    7 minute read

    A comprehensive guide on creating a full-stack Todo list application using ReactJS for the frontend and ASP.NET Core .NET 10 for the backend, featuring both ...

    Mastering SemaphoreSlim for Async Concurrency in C# .NET 10

    6 minute read

    Learn how to use SemaphoreSlim to throttle parallel asynchronous operations in C# .NET 10, preventing resource exhaustion and improving application stability.

    Staying Free: Throttling Google Geocoding API with C# .NET 10

    4 minute read

    Learn how to control your API usage and stay within the Google Geocoding free tier using SemaphoreSlim in C# .NET 10.

    • Follow:
    • GitHub
    • LinkedIn
    © 2026 Thomas Ngo.