CREATE TABLE customer ( CustomerID integer, customer_name text, street text, city text, amount integer ); INSERT INTO customer VALUES (1,'AMIT', 'M.G.road', 'Indore',5000); INSERT INTO customer VALUES (2,'ARPIT', 'Bus stand', 'Bhopal',6000); INSERT INTO customer VALUES (3,'SOURABH', 'Railway station', 'Dewas',1000); INSERT INTO customer VALUES (4,'NEEMA', 'Central library', 'Rewa',8700); SELECT MAX(amount) FROM customer; SELECT MIN(amount)FROM customer; SELECT AVG(amount) FROM customer; SELECT COUNT(*) FROM customer;
To embed this program on your website, copy the following code and paste it into your website's HTML: