# data[].attributes.body
1-SELECT ClassID,StudentName FROM MARKS;

2-SELECT ClassID,StudentName FROM MARKS;

3-SELECT ClassID,StudentName,English FROM MARKS;

4-SELECT * FROM MARKS OrderbyDESC;

# data[].attributes.body
question 4

# data[].attributes.body
Primary key-ClassID

Student name-Text

ClassID-Number

Math-Integer

English-Integer

Science-Integer

History-Integer

Geography-Integer

# data[].attributes.body
1) SELECT Student_Name,Class_ID from MARKS;

2) SELECT Class_ID,Geography from MARKS;

3) SELECT Student_Name,Class_ID,English from MARKS;

4) SELECT Class_ID from MARKS

ORDER BY Class_ID DESC;

EXT: SELECT English from MARKS where English>55;

# data[].attributes.headline
1.	Write an SQL query to display Student Name, Class ID

# data[].attributes.subject
1.	Write an SQL query to display Student Name, Class ID

# data[].attributes.body
2. Write an SQL command to display Class id and geography

Write an SQL command to display student name ,class id and English

Write an SQL command to arrange class id in descending order.

# data[].attributes.body
class id is primary key

student name: text

class id: integer

math: integer

english : integer

science: integer

history: integer

geography: integer

# data[].attributes.body
1.identify the primary key

a.Class ID

2.Write the data types of all the fields

a.Student name-long Text

b.Class ID-Number/integer

c.Maths, English, Science, History, Geography-Integer/number

# data[].attributes.body
data types

.text

.integer

.integer

.integer

.integer

.integer

primary key

-class ID

# data[].attributes.body
float

integer

boolean

character

strings

# data[].attributes.body
Primary Key: Class ID

Write the data types of all the fields?

Student name: text

Class ID: Numbers

Maths: integer

English: integer

Science: integer

History: integer

Geography: integer

# data[].attributes.body
Strings

boolean

character

float

integer

# data[].attributes.body
text

integer

integer

integer

integer

integer

integer

# data[].attributes.body
Strings

Integer

Float

Boolean

character

# data[].attributes.body
1. Class ID

2. Student Name - Text

Class ID - Integer

Maths - Integer

English - Integer

Science - Integer

History - Integer

Geography - Integer

# data[].attributes.body
class ID is the primary key

data types of each field:

student name - string

class id - integer

math, science, english, geograpjy, hitory - integer

# data[].attributes.body
There are data types such as numerical, textual, boolean,

# data[].attributes.body
Data Types Include:

-String

-Integer

-Real

-Boolean

-Float

# data[].attributes.body
Data types

Integer

Float

Boolean

String

Character

# data[].attributes.body
the various data trpes include boolean, character, integer, strngi andfloat