Wednesday 19 June 2019

SQL1 -MLAzure

SELECT
t3.userID AS userID,
t3.placeID AS placeID,
(2015-t1.birth_year) AS age,
weight,
height,
budget,
color,
activity,
religion,
personality,
interest,
hijos,
marital_status,
transport,
ambience,
dress_preference,
drink_level,
smoker,
abs(t1.latitude-t2.latitude) AS latitude_diff,
abs(t1.longitude-t2.longitude) AS longitude_diff,
city,
state,
country,
alcohol,
smoking_area,
dress_code,
accessibility,
price,
Rambience,
franchise,
area,
other_services,
rating
FROM t1, t2, t3
WHERE  t1.userID =t3.userID
AND t2.placeID=t3.placeID;

No comments:

Post a Comment