Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Super Querys Alcántara Noriega Marco Antonio
consulta:- read(X), arbol(X),write(';'). arbol(A):- read(X), (X='tabla'->tabla(A);write("")). tabla(A):- read(T), read(X), (X='tabla'->a2(A,T);(X='fin'->a1(A, T); write(""))). a1(A, T):- write("select "), write(T), write(", count(*)/(select count(*) from "), write(A), write(") as probabilidad from "), write(A), write(" where "), write(T), write(" in(select distinct "), write(T), write(" from "), write(A), write(") group by "), write(T). a2(A, T1):- read(T2), write("select "), write(T1), write(", "), write(T2), write(", count(*)/(select count(*) from "), write(A), write(") as Probabilidad from "), write(A), write(" where "), write(T1), write(" in(select distinct "), write(T1), write(" from "), write(A), write(") and "), write(T2), write(" in(select distinct "), write(T2), write(" from "), write(A), write(") "), write("group by "), write(T2), write(", "), write(T1), write(" order by "), write(T1), write(", "), write(T2). :-consulta.
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
MAX EDUARDO HERNANDEZ RENDON EJERCICIO 2
tarea por punto extra
Examen Int Nego 30-mar-21
TareaPunto
Redes Bayesianas- Medina Paredes
Fii
Arguello Tovar Sheila Arreglos
Karol_lopez_1
Query Industria.
Base del Conocimiento Super Querys
Please log in to post a comment.