You want to retrieve the users who subscribed to the Fitness Newsletter from email accounts.What is the correct way to query the information?

Question

Jason Potter · Accepted Answer

SELECT * FROM fullAccounts WHERE subscriptions..email.isSubscribed=true

Jason Potter · Answer

SELECT * FROM email Accounts WHERE subscriptions..email.isSubscribed=true AND subscriptions. .email.hasFullAccount=true

Jason Potter · Answer

SELECT * FROM email Accounts WHERE subscriptions. email.isSubscribed=true

Jason Potter · Answer

SELECT * FROM emailAccounts WHERE subscriptions..email.hasFullAccount=true

List of questions