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

1 vote111 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
1 vote101 views1 answer
Sql insert for each distinct value
SQL
0 vote113 views1 answer
Drush run sql select
SQL
1 vote96 views1 answer
Join first name and last name sql
SQL
22 votes112 views4 answers
Mysql reset auto increment id
SQL
0 vote129 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote112 views3 answers
Database restoring error
SQL
1 vote127 views1 answer
Sqlite update from another table
SQL
2 votes113 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
9 votes108 views1 answer
Identity insert on sql server
SQL