• 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 - Actors and Directors Who Cooperated At Least Three Times

    February 2, 2024 less than 1 minute read

    Page Navigation

    • Problem
    • Query
    1 min read 45 words

    Problem

    problem

    Query

    SELECT
        actor_id,
        director_id
    FROM
        ActorDirector
    GROUP BY
        actor_id,
        director_id
    HAVING COUNT(timestamp) >= 3
    

    Tags: SQL

    Updated: February 2, 2024

    Share on

    X Facebook LinkedIn Bluesky
    Previous Next

    Leave a comment

    You may also enjoy

    Understanding SelectList in ASP.NET Core MVC .NET 10

    2 minute read

    Dropdown lists are a staple of web forms. Learn how to effectively use SelectList and MultiSelectList in ASP.NET Core MVC to create dynamic, data-driven sele...

    Using JavaScript in ASP.NET Core MVC .NET 10: A Complete Guide

    2 minute read

    Master the art of integrating JavaScript into your ASP.NET Core MVC projects. From script placement to AJAX calls with Antiforgery tokens, learn everything y...

    Deep Dive: AJAX and the Fetch API in ASP.NET Core MVC .NET 10

    1 minute read

    Learn how to implement seamless asynchronous updates in your MVC applications. This guide provides a full, working example of the Fetch API interacting with ...

    Mastering ASP.NET Core Tag Helpers in MVC .NET 10

    2 minute read

    Explore the power of Tag Helpers in ASP.NET Core MVC .NET 10. Learn how they simplify your Razor views with clean, HTML-friendly syntax and discover the most...

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