SQL server query column yes or no

SELECT  a.ID, a.FirstName, a.Lastname,
        CASE WHEN COUNT(b.CustID) > 0 THEN 'YES' ELSE 'NO' END AS HasOrders
FROM    Customer a
        LEFT JOIN Orders b
            ON a.ID = b.CustID        -- <<== the linking column on both tables
GROUP   BY a.ID, a.FirstName, a.Lastname

Similar codes

0 vote344 views1 answer
How to define a save method in ruby for sql databases
SQL
4 votes312 views1 answer
Oracle show error line number
SQL
1 vote343 views1 answer
Postgres get month name from date
SQL
0 vote351 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
2 votes379 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote363 views1 answer
Check if string is a number sql
SQL
1 vote345 views1 answer
Oracle schema size
SQL
1 vote329 views1 answer
Oracle rolling back
SQL
1 vote333 views1 answer
Oracle sql create view
SQL
11 votes376 views2 answers
Having clause in sql
SQL