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 vote153 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
3 votes234 views4 answers
Sql interview questions
SQL
0 vote184 views1 answer
Count column of tables psql
SQL
4 votes135 views2 answers
Insert current date in mysql
SQL
0 vote141 views1 answer
Sql pad left 0
SQL
2 votes140 views1 answer
Q operator in plsql
SQL
0 vote142 views1 answer
Will graphql replace sql
SQL
1 vote163 views2 answers
End mysql command
SQL
1 vote157 views1 answer
Default
SQL
1 vote129 views1 answer
Select dba users oracle
SQL