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 vote389 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote321 views1 answer
Inserting data into different tables at once in oracle sql
SQL
4 votes375 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote336 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote331 views1 answer
Basic structure of sql expression having clause
SQL
10 votes293 views1 answer
Dba_dependencies
SQL
0 vote315 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote336 views2 answers
Sql count number of rows after group by
SQL
57 votes547 views5 answers
How to create a new user in postgresql
SQL
0 vote300 views1 answer
Mysql:5.6 syntax create table
SQL