In SQL, put square braces around an identifier that has spaces in (this includes column names, table names, triggers, etc.)
Select [emp firstname lastname], id,branch([computer science] as cse) from emptable
(Update: per below this is for SQL Server only - for standard SQL use a double quote.)