Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given this table and the query: EMPLOYEE Fname Minit John B Franklin Alicia Jennifer S Ramesh Joyce Ahmad V James E CS Lname San Bdate

image text in transcribed
Given this table and the query: EMPLOYEE Fname Minit John B Franklin Alicia Jennifer S Ramesh Joyce Ahmad V James E CS Lname San Bdate Address Sex Salary Super_san Dno Smith 1234567891965-01-09 731 Fondren, Houston, TXM 30000 333445555 5 Wong 333445555 1956-12-08 638 Voss, Houston, TX M 40000 888665555 5 Zelaya 999887777 1968-01-19 3321 Castle. Spring, TX 25000 987654321 4 Wallace 9876543211941-06-20 291 Berry, Bellaire, TX F 43000 888665555 4 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 5 English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 5 Jabbar 987987987 1969-03-29 980 Dalias, Houston, TX M 25000 987654321 4 Borg 888665555 1937-11-10 450 Stone, Houston, TX M 1 55000 NULL II Sex, Salary (o Sex="F" (EMPLOYEE)) How many rows are returned? Select one: a. 8 b. 10 O c.3 d. 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions