Answered: WORKING IN CENGAGE AND CAN'T FIGURE OUT…

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

WORKING IN CENGAGE AND CAN'T FIGURE OUT THIS TASK. I TRIED OTHER STAEMENTS BUT DID NOT WORK EITHER. PLEASE HELP!

Task 5:

The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team.

You do not need to create a new table in the database schema.

To combine strings into a single column you must use the CONCAT function which combines two or more strings together and its syntax is the following: CONCAT(string1, string2, ....)

Module Lab Assessment 2
TJ
3
bl
CENGAGE MINDTAP
PO
Instructions Page 4 of 5
CONCAT function which combines two or more strings
together and its syntax is the following:
CONCAT (string1, string2, ..)
□
0.00
out of
10.00
a
Checks
Return a list of all the residents and owners
O out of 1 checks passed. Review the results
below for more details.
SQL Database Test Incomplete.
Return a list of all the residents and owners.
Task
Feedback >
Some expected rows were missing (shown in red below).
Some unexpected rows were returned.
Expected Results Ⓡ
PARTICIPANT
Albie O'Ryan
Tariq Khan
Ismail Salib
4/5
query.sql
1 SELECT CONCAT(FIRST_NAME, '
2 SELECT CONCAT(FIRST_NAME,
3
↓
SQL Viewer
Albie O'Ryan
Tariq Khan
Ismail Salib
Callen Beck
Milosz Polansky
Ashanti Lucas
Randy Woodrue
Aislinn Lawrence
StayWell D
X
+
X
> Terminal
SURNAME) AS PARTICIPANT FROM RESIDENTS;
', LAST_NAME) AS PARTICIPANT FROM OWNER;
+
Q Search this course
▸

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions