Question: SQL I am having difficulties combining 3 tables together. . This is what I wrote in SQL: The ERD- - The total number of Toastmasters

SQL

I am having difficulties combining 3 tables together.

.SQL I am having difficulties combining 3 tables together. . This is

This is what I wrote in SQL:

what I wrote in SQL: The ERD- - The total number of

The ERD-

Toastmasters events on Lets Meet The number of Toastmasters events per city.

- The total number of Toastmasters events on Lets Meet The number of Toastmasters events per city. SELECT event.group_id, grp-group_id, city.city_id, grp.city_id from event join event_grp on event.group_id = grp-group_id join group on grp.city_id = city.city_id Where event_name like "toastmaster" or event_name like "Toastmaster%"\; venue grp_member member_id INT(11) city VARCHAR(45) country CHAR(2) hometown VARCHAR(45) joined DATETIME member_name VARCHAR(45) member_status ENUM(...) visited DATETIME group_id INT(11) Indexes category category_id INT(11) ategory_name VARCHAR(45) shortname VARCHAR(45) sort_name VARCHAR(45) Indexes > 1 city city_id INT(11) city VARCHAR(45) state CHAR(2) zip INT(11) country CHAR(2) localized_country_name VARCHAR(45) distance DECIMAL(12,3) longitude DECIMAL(12,8) latitude DECIMAL(12,8) member_count INT(11) ranking INT(11) Indexes gip group_id INT(11) ategory_id INT(11) city_id INT(11) #created DATETIME description LONGTEXT join_mode ENUM(...) ++ group_name VARCHAR(150) rating DECIMAL(4,2) visibility ENUM(...) members INT(11) who VARCHAR(85) Indexes venue_id INT(11) event address_1 VARCHAR(200) event_id VARCHAR(75) address_2 VARCHAR(200) created DATETIME city VARCHAR(45) description LONGTEXT country CHAR(2) duration INT(11) distance DECIMAL(10,2) event_url VARCHAR (250) lat DECIMAL(10,8) Hh group_id INT(11) localized_country_name VARCHAR(45) kheadcount INT(11) lon DECIMAL(12,8) how_to_find_us VARCHAR(250) venue_name VARCHAR(300) maybe_rsvp_count INT(11) phone BIGINT(20) event_name VARCHAR (95) state CHAR(2) photo_url VARCHAR(250) zip INT(11) rs vp_limit INT(11) RANDO) DOUBLE event_status ENUM(...) Indexes event time DATETIME te updated DATETIME utc_offset INT(11) venue_id INT(11) visibility ENUM...) waitlist_count INT(11) why VARCHAR(45) yes_svp_count INT(11) Indexes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!