Recent

Show all results for ""

🎧 New: AI-Generated Podcasts Turn your study notes into engaging audio conversations. Learn more

Feature Overview

Ace your exams with our all-in-one platform for creating and sharing quizzes and tests.

Create quizzes and tests automatically from your content using AI.

Automatically turn your notes into digital flashcards.

Share, Export & Embed

Share with classmates or export to Excel and your learning management system.

Stats & Reporting

Auto-grading quizzes and tests with detailed stats and reports.

The smarter way to study – wherever you are.

Search...

Log in

Log in

SQL Query Writing

4 Questions

0 Views

SQL Query Writing

Created by

@MercifulAbundance

Podcast Beta

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the correct query to retrieve complete data of employee with ID 7?

select * from employee where emp_id=7

select * from employee where Eid=7 (correct)

select * from employee where EmployeeID=7

select * from employee where ID=7

Which query correctly displays/retreives the name of employees with salary greater than 2000?

select Name from employee where salary>2000

select EMPName from employee where salary>=2000 (correct)

select EmployeeName from employee where salary>2000

select Name from employee where salary>=2000

What is the correct query to display/retrieve the average salary in the employee table?

select * from employee where salary=average

select AVG(salary) as [Average Salary] from employee (correct)

select average(salary) from employee

select avg_salary from employee

Which query correctly retrieves records of employees with salary greater than the average salary of all employees?

<p>select * from employee where salary>(select AVG(salary) from employee)</p> Signup and view all the answers

More Quizzes Like This

Defining Database Schema and SQL Queries Quiz

0 questions

Defining Database Schema and SQL Queries Quiz

CheapestJackalope

Database Basics: Data Modeling, SQL Queries, Normalization, and Principles

10 questions

Database Basics: Data Modeling, SQL Queries, Normalization, and Princi...

IncredibleLarch

JDBC: Connecting to a Database and Executing SQL Queries

16 questions

JDBC: Connecting to a Database and Executing SQL Queries

InsightfulCouplet

Database Concepts and Design: Complex SQL Queries

10 questions

Database Concepts and Design: Complex SQL Queries

ColorfulCrocus

Use Quizgecko on...

Browser