当我输入等于一个值时，我的WHERE子句不显示

Question

所以当我放这段代码时，除了end_station_name之外，所有东西都能工作，因为它显示了所有的end_stationname，而不仅仅是"Toomey Rd@South Lamar"；我想怎么做。为什么？

SELECT 
subscriber_type , duration_minutes , end_station_name, start_station_name
FROM 
bigquery-public-data.austin_bikeshare.bikeshare_trips
WHERE (subscriber_type = "Walk Up") OR (subscriber_type = "24-Hour Kiosk (Austin B-cycle)") 
AND end_station_name = "Toomey Rd @ South Lamar"
ORDER BY duration_minutes DESC

Answer 1

这是因为AND运算符的优先级高于OR。你能试着把使用OR的前两个条件放在括号中吗

WHERE ( (subscriber_type = "Walk Up") OR (subscriber_type = "24-Hour Kiosk (Austin B-cycle)") )AND end_station_name = "Toomey Rd @ South Lamar"