Get all students id and name whose marks are greater than average mark in SQL in section STUDENT_MARKS[2 M]StudentId StudentName Gender SQL WebApp Mathematics Course_Section46J12035AzhilaF785989146S11114SulthanM887887146J21113RashidM676971146J22145 MahmoodM777679246S11111MoosaM697172246S21456 MohammedM867891146J14569ReshmaF768677246J24689FatmaF88868146J13564AmaniF798988146J12456NoorF7879762

Query :-- SELECT StudentId, StudnetName FROM STUDENT_MARKS WHERE SQL > (SELECT avg(SQL) FROM…

Answered: Get all students id and name whose…

Engineering

Computer Science

Get all students id and name whose marks are greater than average mark in SQL in section

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: in pl /sql the commend is like this create table bb_basketstatus (idstatus number, idbasket…

A: The answer for the given question is as follows.

Q: Use following oracle table Display the first name and salary*10000 of all employees who works for…

A: Required: Display the first name and salary*10000 of all employees who works for department 50.

Q: SQL Querry Find the list of courses who haven’t got any section opened in Spring 2019. (Use outer…

A: It is simple SQL query to fetch the list of courses who haven't got any section opened in Spring…

Q: Given the table customers which contains columns customer_id, first_name, last_name, and state, and…

A: SELECT C.LASTNAME, A.STATE, A.ZIP FROM CUSTOMER AS C INNER JOIN ADDRESS AS A on…

Q: How does the COALESCE function compare with the ISNULL function when handling NULL values in SQL

A: The COALESCE and ISNULL functions are both used to handle NULL values in SQL. However, they have…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Write PL/SQL cursor to find the commission amount for all the employees whose job_id is SA_MAN Use…

A: The SQL SELECT statement returns a result set of records, from one or more tables. The FROM clause…

Q: I was wondering if you could do this in PL/SQL format. declare begin end; etc

A: DECLARE The user must declare any variable before using it in a batch or method. The memory…

Q: Please written by computer source 1. For this project, you need to create the company database and…

A: Step 1: Create the Company Database Open the Oracle SQL PLUS environment and create a new database…

Q: Write three functions in SQL which does the following: The first function should take an integer…

A: In MYSQL function Syntax to convert number from one base to another follows:- CONV(<num to…

Q: Write a query that Balance of each CUSTOMER who have made purchase(s) before AND subtotal that each…

A: Sql which means structured query languages and it is a domain-specific language used in programming…

Q: N SQL: For every customer, list the customer number, the customer's entire zip code, and add two…

A: SQL-CREATE TABLE AND INSERT VALUES: BEGIN TRANSACTION; /* Create a table called CUSTOMER */CREATE…

Q: Create a procedure in PL/SQL takes Department Id and return record data type has maximum salary,…

A: Find the required procedure in PL/SQL given as below :

Q: How does the PATINDEX function help in string pattern matching in SQL?

A: Relational databases are managed and worked on using the programming language SQL (Structured Query…

Q: UPDATE NONCAT SET Category =NULL WHERE ITEM_ID = UF39; Task 7: In the NONCAT table, change the…

A: Solution: UPDATE NONCAT SET Category =NULL WHERE ITEM_ID = 'UF39';

Q: We have a single customer with the surname "Ashworth", write the SQL to return the Firstname,…

A: -- create a tableCREATE TABLE customers ( FirstName varchar(255),Surname varchar(255),Phonenumber…

Q: Translate the following SQL query to a pandas statement in Python so that it can be executed on the…

A: count(*)-count number of rows satisfying the condition sqldta-table name conditions;- case>1000…

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: )…

A: Below is the required procedure:

Q: Using Salesforce Only: Write a SOQL query on account object and try to get the 5 fields value which…

A: What is SOQL: SOQL stands for Salesforce Object Query Language. You can use SOQL to read information…

Q: instrument category category name varchar(255) varchar(255 rchar(255) instrument id Ezzzzz

A: Answer: In this subquery First of all with the help of join we will connect three table Instrument,…

Q: Imagine that you are a database manager at a company that makes custom shirts. One column in the…

A: Create the sample table shirts having columns idshirt as integer and autoincremented, wholesaleprice…

Q: Use following oracle sql table Display the first name, last name and salary of all employees hired…

A: Required: Display the first name, last name and salary of all employees hired after “01-JAN-2006‟.

Q: NVL to replace null value.

A: NVL: The NVL() function allows to replace null value with meaningful alternative in the results of…

Q: Refer to the film and inventory tables of the Sakila database. The tables in this lab have the same…

A: Structured query language SQL is a standard language for storing, manipulating and retrieving data…

Q: plz fix the following so it runs on sql developper or sql live CREATE TABLE DONORS ( donor_id INT…

A: Need to fix the given query :CREATE TABLE DONORS (donor_id INT NOT NULL,donor_name varchar(255) NOT…

Q: Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family…

A: Since I don't have access to the database, I am writing the general syntax of deleting the rows from…

Q: operands matters in

A: MINUS QueryA Minus Query is a SQL query that uses the MINUS operator to calculate the difference…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

Get all students id and name whose marks are greater than average mark in SQL in section

STUDENT_MARKS
[2 M]
StudentId StudentName Gender SQL WebApp Mathematics Course_Section
46J12035
Azhila
F
78
59
89
1
46S11114
Sulthan
M
88
78
87
1
46J21113
Rashid
M
67
69
71
1
46J22145 Mahmood
M
77
76
79
2
46S11111
Moosa
M
69
71
72
2
46S21456 Mohammed
M
86
78
91
1
46J14569
Reshma
F
76
86
77
2
46J24689
Fatma
F
88
86
81
46J13564
Amani
F
79
89
88
1
46J12456
Noor
F
78
79
76
2

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

If item price*item quantity is a computed field in Oracle, how does it compare to the table field?
i amm trying to do some work in sql developer insert data from nametest to names i want only to insert year ,name and gender ,then create a id for each data in the databse . what commend shouldi use ? i try "INSERT INTO names(Year, Name, gender),SELECT (Year_, name_, genderA) FROM namestest; it shows Error starting at line : 1 in command -INSERT INTO names(Year, Name, gender),SELECT (Year_, name_, genderA) FROM namestestError at Command Line : 2 Column : 21Error report -SQL Error: ORA-00926: missing VALUES keyword00926. 00000 - "missing VALUES keyword"*Cause: how to make it corrrect ?and make a "id "for each data ?
In SQL, write the appropriate statements to insert default values for these two tables, each table containing 5 inserts
Why it's useful to have index that partially sort a query if it doesn't present all of the results already sorted?
how to delete department id in pl/sql from department id - 60 otherwise raise an exception
Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).
Explain set operator in SQL
SOQL Assignment: You have to write a SOQL Query In which we have to find all the contact whose accountld is not null and Order the First Name in Descending order.
on this table CREATE TABLE students ( std_id int NOT NULL PRIMARY KEY, f_name VARCHAR2(20), l_name VARCHAR2(20), std_address VARCHAR2(50), tel_no VARCHAR2(15), SEX VARCHAR2(10), birthdate date ); use PL/SQL oracle to solve create A Function getAllData(arg): When Your call your function it should search about an item in your table and returns all data about it. arg is int all data are int and varchar2 and date