What is the syntax of the INSERT and SELECT commands in SQL?

-- INSERT syntax  
-- Insert all columns, explicitly specifying their order  
INSERT INTO table_name (column1, column2, column3, ...)  
VALUES (value1, value2, value3, ...);  
  
-- Insert all columns in the order they are defined in the table  
INSERT INTO table_name  
VALUES (value1, value2, value3, ...);  
  
-- Insert rows from another SELECT query  
INSERT INTO table_name (column1, column2, column3, ...)  
SELECT column1, column2, column3, ...  
FROM source_table  
WHERE condition;  

-- SELECT syntax  
-- Select all columns  
SELECT *  
FROM table_name  
WHERE condition;  
  
-- Select specific columns  
SELECT column1, column2  
FROM table_name  
WHERE condition;  
  
-- Select with aggregation and grouping  
SELECT column1, COUNT(column2) as count_column2  
FROM table_name  
WHERE condition  
GROUP BY column1  
HAVING COUNT(column2) > 10  
ORDER BY column1 DESC;  
  
-- Select with table joins  
SELECT t1.column1, t2.column2  
FROM table1 t1  
JOIN table2 t2 ON t1.id = t2.id  
WHERE t1.condition;  
  
-- Using DISTINCT for unique values  
SELECT DISTINCT column1  
FROM table_name;  
  
-- Limit the number of rows  
-- Syntax may vary depending on the DBMS (LIMIT, TOP)  
SELECT *  
FROM table_name  
LIMIT 10; -- For MySQL, PostgreSQL  
  
-- SELECT TOP 10 * FROM table_name; -- For SQL Server