Write a query to create a view to show only 'acc_id' and 'status' columns and then show that view.

Question

error in data table

Answer 1

create view <ViewName> as
select acc_id, status
from <tableName>

Well it seems this question is from SQL so I've answered it accordingly

Answer 2

create view list as
select acc_id, status
from users;
select * from list