Dato il seguente schema logico: user( email , name, surname, street, city, zi...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Dato il seguente schema logico:
user(email , name, surname, street, city, zip, number_photos, type, password, active)
photo(name , date, time, subject, views, total_votes, longitude, latitude, user_email(FK), typology_name(FK))
judges(id, user_email(FK), photo_name(FK), comment, rating)
typology(name)
Selezionare il nome delle tipologie di foto che come soggetto contengano la parola montagne e che siano state scattate nel 2020
Se necessario utilizzare le SUBQUERY
Want instant access to all verified answers on moodle.edu.ti.ch?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!