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 vote120 views1 answer
Postgresql if else endif
SQL
0 vote134 views1 answer
Sqlite unique multiple columns
SQL
0 vote118 views1 answer
Sql server select ignore dupplicates
SQL
2 votes116 views1 answer
Sqlite show table indexes
SQL
1 vote113 views1 answer
Mysql show table character set
SQL
1 vote114 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
5 votes120 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
1 vote109 views1 answer
How to use a trigger to validate input data
SQL
0 vote124 views1 answer
Mysql root permission denied lost
SQL
1 vote118 views1 answer
Sql select where id not exists in another table
SQL