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 vote150 views1 answer
Insert using condition postgres
SQL
0 vote151 views1 answer
Check for directory in bash
SQL
0 vote195 views1 answer
Postgres dump sql insert
SQL
0 vote288 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote134 views1 answer
Check index sql server
SQL
7 votes144 views1 answer
Oracle pagination query offset
SQL
3 votes151 views1 answer
Sql online test questions and answers
SQL
0 vote100 views1 answer
Check if due date is less than todays date sql
SQL
17 votes137 views6 answers
Sql select distinct
SQL
2 votes152 views1 answer
How to get non distinct values in sql
SQL