15. List the first name for all contacts and whether they have a spouse or not (yes/no). Order by the first name. For example, your result set might look like this: | firstname | Married? | Biff | George | Jennifer | Lorraine | Marty | no | yes | no | yes | no

New Perspectives on HTML5, CSS3, and JavaScript
6th Edition
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Patrick M. Carey
Chapter13: Programming For Web Forms: Creatings Forms For Orders And Pa
Section13.2: Visual Overview: Passing Data Between Forms
Problem 3QC
icon
Related questions
Question
+----+
+-
--+-
| id | firstname | lastname | spouse_id |
+---
+
1 | Marty
2 | Jennifer
3 | Lorraine
4 | Biff
5 | George
| McFly
| Parker
NULL |
NULL |
|
|
| McFly
| Tannen
| McFly
5 |
NULL |
|
3 |
+----+
Transcribed Image Text:+----+ +- --+- | id | firstname | lastname | spouse_id | +--- + 1 | Marty 2 | Jennifer 3 | Lorraine 4 | Biff 5 | George | McFly | Parker NULL | NULL | | | | McFly | Tannen | McFly 5 | NULL | | 3 | +----+
15. List the first name for all contacts and whether they have a spouse or not (yes/no). Order by the first
name. For example, your result set might look like this:
| firstname
| Married?
|
| Biff
| George
| Jennifer
| Lorraine
| Marty
| no
| yes
| no
| yes
| no
Transcribed Image Text:15. List the first name for all contacts and whether they have a spouse or not (yes/no). Order by the first name. For example, your result set might look like this: | firstname | Married? | | Biff | George | Jennifer | Lorraine | Marty | no | yes | no | yes | no
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Complex Datatypes
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning