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 vote168 views1 answer
Mysql text to decimal
SQL
8 votes224 views2 answers
Change name of colum in sql table
SQL
0 vote189 views1 answer
Replace sqlalchemy
SQL
0 vote166 views1 answer
Sql select duplicates based on two columns
SQL
1 vote187 views1 answer
Sql select table header
SQL
3 votes256 views3 answers
Mysql get table size
SQL
0 vote155 views1 answer
Sql random decimal
SQL
1 vote166 views1 answer
Primary key with prefix sql
SQL
0 vote156 views1 answer
Oracle activate program
SQL
0 vote185 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL