1. Two dice are rolled. There are 36 possible outcomes, the
sample space is:
(1,1) (1,2)...
1. Two dice are rolled. There are 36 possible outcomes, the
sample space is:
(1,1) (1,2) (1,3) (1,4) (1,5) (1,6) (2,1) (2,2) (2,3) (2,4)
(2,5) (2,6) (3,1) (3,2) (3,3) (3,4) (3,5) (3,6) (4,1) (4,2) (4,3)
(4,4) (4,5) (4,6) (5,1) (5,2) (5,3) (5,4) (5,5) (5,6) (6,1) (6,2)
(6,3) (6,4) (6,5) (6,6)
A = ‘second roll is a 6’
B = ‘sum of two dice equals 7’
C = ‘sum of two dice equals 3’
a. What is P(B|A)?
b. What is...
Question 1: Roll two fair dice. Then the sample space S is the
following.
S =...
Question 1: Roll two fair dice. Then the sample space S is the
following.
S =
(1,1) (1,2) (1,3) (1,4) (1,5) (1,6)
(2,1) (2,2) (2,3) (2,4) (2,5) (2,6)
(3,1) (3,2) (3,3) (3,4) (3,5) (3,6)
(4,1) (4,2) (4,3) (4,4) (4,5) (4,6)
(5,1) (5,2) (5,3) (5,4) (5,5) (5,6)
(6,1) (6,2) (6,3) (6,4) (6,5) (6,6)
Let E be the event that the sum of the dice is odd, let F be the
event that the first die lands on 1,
and let G...
using mysql lyrics.database. i will provide the lyrics schema
database info below
1. List the first...
using mysql lyrics.database. i will provide the lyrics schema
database info below
1. List the first name, last name, and region of members who do
not have an email.
2. List the first name, last name, and region of members who do
not have an email and they either have a homephone ending with a 2
or a 3.
3. List the number of track titles that begin with the letter
's' and the average length of these tracks in...
Q1. Use Union statements to show the following: list the number of artists that have a...
Q1. Use Union statements to show the following: list the number of artists that have a webaddress, the number of artists that do not have a webaddress, and the total number of artists. The output should look like:
+--------------------------+----------+
| Has webaddress | count(*) |
+--------------------------+----------+
| Has webaddress | 5 |
| Does not have webaddress | 6 |
| Total | 11 |
+--------------------------+----------+
Q2. A new salesperson has been hired. Their SalesID is 5, full name is...
Describe what the following query does using lyrics database
with mysql. lyrics database is posted below...
Describe what the following query does using lyrics database
with mysql. lyrics database is posted below
1.)
select m.lastname, m.firstname, s.lastname
from members m inner join salespeople s using (salesID)
order by m.lastname asc;
2.)
select studioID, studioname, base
from salespeople sa inner join studios st
on (sa.salesID = st.salesid)
where base < 300
3.)
SELECT artistName
FROM Artists
WHERE artistID IN
(SELECT artistID
FROM Titles)
DROP TABLES IF EXISTS Artists,Genre, Members, Titles,
Tracks,SalesPeople,Studios,XrefArtistsMembers;
DROP TABLES IF EXISTS
Authors,Publishers,Titles,Title_Authors,Royalties;
DROP...