Chapter 6, Problem 9HOA

Some rows of a User table are shown below:   User ucode name phone scode 7 Alex 847 - 3902 UX 8 Tony 203 - 3902 PX 9 Charles ​ BD 11 Mary 877 - 3333 BD   Which of the following queries retrieves the rows where there is no phone? ​   a. SELECT * FROM User WHERE phone IS NULL   b. SELECT * FROM User WHERE phone = “ ”   c. SELECT * FROM User WHERE phone NOT IS NULL   d. SELECT * FROM User WHERE phone > 0

1- List all the users and their card name using union2- List all the users and their card name using Intersection 3- List all the card numbers with owner names and scheduled transactions, in case the user hasnever used scheduled transaction show null or zero in the transaction column. (Hint use ISNULLfunction)

The PatientDim table contains columns. PatientEpicId and name. Use the following query to answer the questions below it: SELECT PatientEpicID Name FROM PatientDim What does this query return?   select one of the following: A. Nothing because the query won't run.B. The column PatientEpicId and name from the table PatientDimC. The PatientEpicID column  from the table PatientDim, with an alias of name.D. The name column from the table PatientDim, with an alias of PatientEpicId

Create the following tables using MySQL CLI. Take a screenshot of each CREATE TABLE command that is successfully executed. School Column Name Data Type Length Decimal Places Primary Key? schoolNumber Integer     yes name VarChar 200     address VarChar 95     phoneNumber VarChar 10     built Date       size Integer

In Access, create an SQL query that calculates how many different therapies have not been booked yet.

Create a query to concatenate the street address so you print stadr followed by a comma and a space and then city followed by a comma and a space and then state followed by a space and then zip

Create a trigger named trg_cust_balance that automatically updates the CUSTOMER table’s CUS_BALANCE when a new CHARTER row is added. Use the CHARTER table’s CHAR_TOT_CHG as the update source. (Assume that all charter charges are charged to the customer balance.)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show database CREATE DATABASE [Da]USE PETSTORE' at line 3mysql> use petstoreERROR 1049 (42000): Unknown database 'petstore'mysql> create database [da]    -> use petstore    ->    -> CREATE TABLE USERS (user_id VARCHAR(30), password    -> VARCHAR(30), first_name VARCHAR(50), last_name VARCHAR(50));ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[da] ========== whats the wrong with this work , what code is correct when i ma trying to make a new table and a new databse in this mysql commend line ?

I need the output of the queries      create table Accounts (account_no number primary key, client_name varchar2(200),Gender varchar2(20),address Varchar2(200)); create table loans (branch_id number, bank_name varchar2(200),Loan number, loan_Status varchar2(200),account_no number references Accounts(account_no) ON DELETE CASCADE);   1. delete from accounts where account_no= 101; 2. select * from accounts  a where exists (select 1 from loans l where l.account_no= a.account_no) 3. select * from accounts a  where exists (select 1 from loans l  where l.account_no= a.account_no and status = 'accepted') 4. create or replace view view1 as select client_name , address,l.bank_name,l.loan_Status from accounts a, loans l where a.account_no = l.account_no Step 2 5.create or replace view view2  as  select client_name , address,l.bank_name,l.loan_Status from accounts a, loans l where a.account_no = l.account_no and address = 'Karachi' 6. create or replace view view3 as  select client_name ,…