BRANCH (branch no, street, area, city, degree, Tel_no, Fax_no) STAFF (Staff no, Fname, Lname. address, position, salary, branch_no) Write the following queries in SQL: 1. Find all the branches that number less than 453 and found in area '34 east 2. Find staff whose salary is greater than the salary of every member of staff at branch 71. 3. List all stalf who their last name ends with 'ith'. 4. Find all the staff that works in branch 345 and have salary between 15000 and 45000.

BRANCH (branch no, street, area, city, degree, Tel_no, Fax_no) STAFF (Staff no, Fname, Lname. address, position, salary, branch_no) Write the following queries in SQL: 1. Find all the branches that number less than 453 and found in area '34 east 2. Find staff whose salary is greater than the salary of every member of staff at branch 71. 3. List all stalf who their last name ends with 'ith'. 4. Find all the staff that works in branch 345 and have salary between 15000 and 45000.

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

Similar questions

Please help: Using the following sql file, how would you find List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number. Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End; //* Assignment_1 */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…
This is in sql. For all artists who are currently in a band: Return the artist’s full name (as a single value), the band name, and how long in years the artist has been in the band. The artist should only be shown once for each band. (Hint: Remember that the data might include an artist who left a band and then rejoined. That is the challenge here!) Tables with values are in image.
Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…
Using SQL: List the title_name and book type of books that have the lowest royalty rate.
what is the difference between inner and outer join in sql?
Write SQL codes according to the requirements given. Tables are imaginary, column names can be made up. List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) List the invoice number and invoice date for each invoice created for the customer James Gonzalez. Use a subquery to find the sales rep ID, first name, and last name of each sales rep who represents at least one customer with a credit limit of $500. List each sales rep only once in the results.
Write in SQL
Write SQL CODE List all the Course Code (CRS_CODE) that are taught by a Professor that does not hold "Ph.D." as the highest degree (based on PROF_HIGH_DEGREE in the PROFESSOR table).
Create a PL/SQL query to display the customer’s name, employee name, donation, dispatch date and the delivery date. In your query, also display the number of days between the dispatch date and the delivery date in days for customer 11013.
how do you use PL/SQL or T-SQL procedures in SQL?
Include both SQL commands and SQL results in your answers: KimTay Pet Supplies is running a promotion that is valid for up to 20 days after an order is placed. List the invoice number, customer ID, customer first and last names, and the promotion date for each invoice. The promotion date is 20 days after the invoice was placed. Write PL/SQL (or MySQL) procedures to accomplish the following task: The procedure accepts the ID of a customer stored in the input variable named I_CUST_ID and displays the name (first name concatenated with last name) and credit limit of for this customer.
Subject: DatabaseWrite the SQL statements for following modification tasks: a) Add constraint to the table BORROWER named borrower_cardno_pk to create the attribute name as the primary key. b) Delete the column city from the table BORROWER c) Modify the column of "phone" in table BORROWER, change the data type into type of VARCHAR2 with length of 20.