GET QUOTE IN 2 MINUTES*
Order Now
Assignment Writing
Display the student Roll, Name , Marks and Percentage of Marks (Out of 120). Note that the heading of last column should be “PERCENTAGE”.
INSTRUCTIONS TO CANDIDATESANSWER ALL QUESTIONS
ASSIGNMENT- 2
(SQL OPERATOR)
Consider the following Table and answer the following question -
|
TABLE: STUDENT |
||||
|
ROLL |
SNAME |
STR |
MARKS |
CITY |
|
----- |
--------------- |
--- |
---------- |
---------- |
|
MC01 |
Abir Roy |
MCS |
72 |
KOLKATA |
|
MC02 |
SUMIT DUTTA |
MCS |
56 |
KOLKATA |
|
BCA1 |
SAYAN DAS |
BCA |
88 |
GARIA |
|
BCA2 |
RIA |
BCA |
64 |
KOLKATA |
|
BCA2 |
RIA |
BCA |
64 |
KOLKATA |
|
BCA5 |
RITA GHOSH |
BCA |
72 |
DUMDUM |
|
BBA9 |
Abir Das |
BBA |
|
KOLKATA |
- Display the student Roll, Name , Marks and Percentage of Marks (Out of 120). Note that the heading of last column should be “PERCENTAGE”.
- Display the Table contents as following-
REPORT
- Abir Roy got 72 marks.
SUMIT DUTTA got 56 marks.
SAYAN DAS got 88 marks.
... ... ... ....
... ... ... ....
- Display the student information who got less than 60
- Display the student information who did not get more than 77
- Find the BCA students who got more than 80
- List the students name and marks who got below 60 and more than 80
- List the students name and marks who got 60 to 80
- Find the student whose mark is unknown/empty.
- Find the student names starting with
- Find the student names starting with A or ending with
- Find the student whose surname starts with
Attachments:
Related Questions
. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C
DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma
. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an
Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t
. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual
Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th
. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:
1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of
. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:
1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of
