In this MySQL challenge, your query should return the number of rows from your table where FirstName contains "e" and LastName has more than 5 characters. Your output should look like the following table. +--------------+ | count (*) | +--------------+ | 2 | +--------------+
Added by Nicole H.
Close
Step 1
You are asked to count the number of rows in a table based on two conditions: - The `FirstName` column must contain the letter "e". - The `LastName` column must have more than 5 characters. Show moreβ¦
Show all steps
Your feedback will help us improve your experience
Akash M and 91 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
In this MySQL challenge, your query should return the number of rows from your table where FirstName contains "e" and LastName has more than 5 characters. Your output should look like the following table. count(*) 2
Supreeta N.
Department with Student Count #SQL Query Required only* Write query to display list department names and number of students in that department where students exist. Give an alias to the count as STUDENT_COUNT. Sort the records based on department name. Refer to the below schema diagram: College Management System (CMS) Department department_id number - PK department_name varchar(50) Student student_id number - PK student_name varchar(30) address varchar(50) city varchar(30) department_id number - FK Subject subject_id number - PK subject_name varchar(20) subject_code varchar(10) Status status_id number - PK status_name varchar(30) Mark value number subject_id number - PKFK student_id number - PKFK
Madhur L.
Finding Duplicate Actors Notes Code Problem Your task is to write an SQL query that finds all entries in the Actor table where the first_name and last_name are the same as another actor's first and last names. For example: actor_id | first_name | last_name 1 | JOHN | APPLESEED 22 | JOHN | APPLESEED 32 | MARK | ZUCKERBERG 44 | MARK | ZUCKERBERG (4 rows) Your query's result table must contain these columns: 1. actor_id 2. first_name; and 3. last_name. The results should be listed in alphabetical order by first_name and last_name, then in increasing order by actor_id for actors with the same names. Try to use SQL's CROSS JOIN operator in your answer! Film film_id title description length release_year rental_duration rental_rate replacement_cost rating special_features language_id original_language_id Film_Actor film_id actor_id Actor actor_id first_name last_name nationality Country country_id short_code name Film_Category film_id category_id Category category_id name parent_cat Language language_id name Overview of the tables in the film database schema.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD
