Question 1 = (Single UPDATE Statement) With a single statement change the emails

Question

Question 1 = (Single UPDATE Statement)
  
   With a single statement change the emails of all the members to the format "LastName@ArtistName.com".
   Use the replace function to get rid of spaces in the artistname
   e.g.
   SELECT REPLACE(ArtistName, " ", "") FROM Artists;
   The above lists all the artistnames with spaces removed

   After you are done, this is how the output should look like:
   mysql> select firstname, email from members;
   +-----------+-----------------------------+
   | firstname | email |
   +-----------+-----------------------------+
   | Bryce | Sanders@TheNeurotics.com |
   | Marcellin | Lambert@Sonata.com |
   | Caroline | Kale@Sonata.com |
   | Kerry | Fernandez@Sonata.com |
   | Roberto | Alvarez@Word.com |
   | Mary | Chrisman@Word.com |

Question 2 = English to SQL
   Show the names of all salespeople who represent members of the Bullets. Do not use joins, use subqueries only.

Tracks TitleID TrackNum TrackTitle LengthSeconds MP3 RealAud Titles Title ID ArtistID Title Studi oID UPC Gee nre Genre B Genre Artists Y ArtistID ArtistName City Region Country Web Address Entry Date Lead Source Xref Artists Members MemberID V Y Art tID RespParty Studios StudioID StudioN ame Address City Region PostalCode Country WebAdd Contact: EMa Phone Sales ID Members B MemberID ame LastName Address City Region PostalCode Country HomePhone Work Phone EMa Gender Birthday SalesID Sales People Sales ID FirstNam La Name nitials Base Supervisor

Explanation / Answer

The contacts shown in your Outlook 2007 Contacts envelope make up the substance of the Outlook Address Book. You can likewise make and name different Contacts organizers, and in each of these envelopes you can change the name design. Nonetheless, you can't change the show arrangement of names in the Microsoft Exchange Global Address List (GAL). The configuration for names in the GAL is set by your association's overseer.
Disclose to me more about the address books
Worldwide Address List (GAL)     To show this address book, you should utilize a Microsoft Exchange Server account. The GAL contains the names and email locations of everybody in your association. The GAL is consequently designed with an Exchange account. The Exchange manager or system director makes and keeps up the GAL. The GAL can likewise contain email addresses for outside contacts, circulation records, meeting rooms, and hardware.
Viewpoint Address Book     This address book does not oblige you to utilize an Exchange account. The Outlook Address Book is made consequently and contains the contacts in your default Contacts organizer that rundowns either email addresses or fax numbers. These contacts are shown in the Address Book discourse confine when you click Contacts the Address Book list.
On the off chance that you make extra contacts envelopes, you can set the properties for every organizer to incorporate the contacts as a component of the Outlook Address Book.
You can likewise change the name arrange for different address books that you make in Outlook. For more data, see Add or expel an address book.
To view all accessible address books, click Address Book on the toolbar, and after that tap the bolt beneath Address Books.
Each of your Contacts organizers is recorded in the Address Books list.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.