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 vote322 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote318 views1 answer
Postgres where
SQL
2 votes342 views2 answers
Convert_tz mysql
SQL
0 vote317 views1 answer
Postgres call view
SQL
0 vote316 views1 answer
C# datetime to sql server datetime
SQL
0 vote366 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote369 views1 answer
Mysql relationships between tables
SQL
0 vote352 views1 answer
Ajouter une clé etrangere mysql
SQL
2 votes281 views1 answer
Oracle current date without time
SQL
2 votes303 views1 answer
Username sql
SQL