emilynlacao

hi ate CREATE TABLE statement is used to create a table in a database. Tables are organized into rows and columns; and each table must have a name. example:CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), column_name3 data_type(size), .... );

hi ate LIKE operator is used in a WHERE clause to search for a specified pattern in a column,and also used to search for a specified pattern in a column. example:SELECT * FROM Customers WHERE Country NOT LIKE '%land%';

you can try this some of fuctions; Useful aggregate functions: AVG() - Returns the average value COUNT() - Returns the number of rows FIRST() - Returns the first value LAST() - Returns the last value MAX() - Returns the largest value MIN() - Returns the smallest value SUM() - Returns …