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 vote159 views1 answer
Finish transaction sql
SQL
1 vote227 views1 answer
Oracle select first row order by
SQL
0 vote207 views1 answer
Sub query in linq
SQL
0 vote197 views1 answer
Changer un mot de passe mysql
SQL
1 vote212 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote189 views1 answer
Insert or update cassandra
SQL
0 vote199 views1 answer
Jooq replace
SQL
0 vote214 views1 answer
Set root password mysql xampp
SQL
46 votes216 views4 answers
Create column sql
SQL
1 vote174 views1 answer
Enable mysql slow query log
SQL