-- create a table
/* printing table in descending order*/
CREATE TABLE Student1(rollno int,name varchar(255),registration varchar(255));
insert into Student1(rollno, name, registration)values(01,"Coura1",12216237);
insert into Student1(rollno, name, registration)values(02,"Coura2",12216238);
insert into Student1(rollno, name, registration)values(03,"Coura3",12216239);
insert into Student1(rollno, name, registration)values(04,"Coura4",12216240);
insert into Student1(rollno, name, registration)values(05,"Coura5",12216241);
insert into Student1(rollno, name, registration)values(06,"Coura6",12216242);
select * from Student1;
SELECT * FROM STUDENT1
ORDER BY REGISTRATION DESC;

-- descending order by registration 

-- Every table is broken up into smaller entities called fields. The fields in the Customers
-- table consist of CustomerID, CustomerName, ContactName, Address, City, PostalCode and 
-- Country. A field is a column in a table that is designed to maintain specific information 
-- about every record in the table.

-- A record, also called a row, is each individual entry that exists in a table. For example,
-- there are 91 records in the above Customers table. A record is a horizontal entity in a 
-- table.

-- A column is a vertical entity in a table that contains all information associated with a 
-- specific field in a table.