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

2 votes407 views2 answers
Set value to null sql
SQL
15 votes366 views4 answers
Export mysql db using command line
SQL
0 vote339 views1 answer
Mysql command line ubuntu
SQL
0 vote365 views1 answer
Import sql inside hide sql
SQL
0 vote339 views1 answer
Oracle sql winter time change
SQL
0 vote328 views1 answer
Difference between cross apply and inner join
SQL
1 vote348 views1 answer
Mysql remove last empty newline
SQL
2 votes363 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
2 votes365 views1 answer
Postgresql update sequence next value
SQL
0 vote335 views1 answer
Minecraft duping allowed servers
SQL