The following are some basic rules you need to create a view. I have shared already what is read only view and updatable view. Views are dependent on base tables. You can find differences of Views and Table here.
No ORDER BY inside the View CREATE
All Aggregation needs to have an ALIAS
Any Derived columns (such as Math) needs an ALIAS
The sample SQL query useful to create view in your project
CREATE View Department_Salaries AS SELECT Dept_No ,SUM(Salary) as SumSal ,SUM(Salary) / 12 as MonthSal FROM Employee_Table GROUP BY 1;
The above is the query to create a view. You can read one more example to create a view.
However, the SQL below is to retrieve data from SQL query
SEL * FROM Department_Salaries Order By 1 ;
Dept_No SumSal MonthSal ________ ________ __________ ? 32800.50 2733.38 10 64300.00 5358.33 100 48850.00 4070.83 200 89888.88 7490.74 300 40200.00 3350.00 400 145000.00 12083.33
Also read how Salesforce is using AI without SQL for your quick reference.