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 vote118 views1 answer
Now() -1 mysql
SQL
0 vote183 views1 answer
Set root password mysql xampp
SQL
0 vote177 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote164 views1 answer
How to query all tables mysql at the same time
SQL
2 votes162 views2 answers
Select list is not in group by clause
SQL
0 vote161 views3 answers
Database restoring error
SQL
7 votes167 views1 answer
Oracle reset sequence
SQL
2 votes108 views1 answer
Select sid oracle
SQL
0 vote159 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote194 views1 answer
Set Mamp mysql globally
SQL