I have a table that has city, state, and zip columns.
When I write a query as follows:
select city, state, zip from address_table
it will give me what I have in the table, but I want to create a virtual column with default value in my sql statement. For example
select city, state, zip, county from address_table
I don't have a county
column in my table and I don't want to add that to my table. I want to create a county
column in my sql statement with a default value 'Los Angeles'. How do I write a sql statement that will show all the value in the address_table and plus a virtual column with default values of 'Los Angeles'?