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

5 votes282 views1 answer
Invalid column name sql
SQL
4 votes261 views1 answer
Postgresql create table with index
SQL
0 vote326 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote253 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
1 vote259 views1 answer
Sql sort column by date
SQL
2 votes270 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote298 views1 answer
Mysql average from two table
SQL
0 vote260 views1 answer
Mysql_error replacement
SQL
-1 vote271 views5 answers
Online sql to linq generator
SQL
0 vote242 views1 answer
Mysql events not work
SQL