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

7 votes145 views1 answer
Query postgres delete duplicates
SQL
0 vote164 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote159 views1 answer
How to get button for every record from mysql
SQL
1 vote141 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
2 votes138 views3 answers
How to check current user in mySQL
SQL
0 vote150 views1 answer
How to run mysql on terminal mac
SQL
1 vote139 views1 answer
Md5 encryption for existing records
SQL
2 votes137 views2 answers
Useradd postgres
SQL
1 vote140 views1 answer
Mysql view command
SQL
28 votes191 views6 answers
Foreign key
SQL