Which one is correct about the data returned by the following SQL$?$

select c$.$customer$\_$id$,$ c$.$customer$\_$fname, o$.$order$\_$id$,$ o$.$order$\_$date, o$.$order$\_$status from customers as c$,$ orders as o

where c$.$customer$\_$id $=$ o$.$order$\_$customer$\_$id and o$.$order$\_$date $>\text{'}2014-7-23\text{'}$

order by c$.$customer$\_$id;

it has all columns from $2$ tables

it has $2$ columns

it has $5$ columns

it has all columns from $1$ table