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

3 votes191 views1 answer
Select count from table mysql
SQL
1 vote178 views3 answers
Rename table snowflake
SQL
0 vote186 views1 answer
Price-colour
SQL
1 vote176 views1 answer
Sql restore backup query
SQL
0 vote191 views1 answer
Windows aggregate functions in postgresql
SQL
1 vote224 views1 answer
Find difference in dates sql
SQL
0 vote203 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote195 views1 answer
Mysql workbench primary key
SQL
3 votes237 views1 answer
Sql several or
SQL
1 vote369 views2 answers
Sql unique rows
SQL